Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
logical functions think

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Logical Functions (i think)

Logical Functions (i think)

ResolvedVersion 2003

Jeff has attended:
PowerPoint Intermediate Advanced course

Logical Functions (i think)

I am looking to perform the following:

- If a particular cell contains a value (text / number) then show this value in a different destination cell.

- If a particular cell doesn't contain a value (text / number) then leave the destination cell blank.

I've had an attempt or two but am struggling.

I need this for a report i am looking to submit by close of business today.

Thanks in advance

Jeff

If the above is not clear my contact number is 07525 702 595

RE: Logical Functions (i think)

Hi Jeff

Thank you for your question

You are indeed correct in your assumption that an if function is the correct way to go. I have created a sheet with a simple example of what you describe.

I suggest that you select a cell that contains one of the IF functions and active the paste function tool to see how it works

If you have any other queries, please feel free to repost

Regards

Stephen

Attached files...

If Function.xls

Mon 30 Nov 2009: Automatically marked as resolved.

Please browse our web site to find out more about
advanced excel seminar training and other training courses.

Excel tip:

Formula for last day of month

In some cases it is necessary to find the last day of a month for a given date. If you use the following formula, you can achieve this, ie; if you have a column of dates, use this formula to find the end of month for each day by using the fill handle. The formula is as follows, and assumes in this example that the first date in question is in cell C5, in any other cell type; =DATE(YEAR(C5),MONTH(C5)+1,1)-1

View all Excel hints and tips

TrustPilot
TrustScore 4.9 / 5       2394 reviews

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

STL training logo

Formerly Best Training
© 2025 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE

2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT, United Kingdom.

Verified by Visa
Security verified
Microsoft Partner
Terms & Conditions Privacy & Cookie Policy Consent preferences
Server loaded in 0.1 secs.