Logical Functions (i think)

Resolved · Urgent Priority · Version 2003

Tue 24 Nov 2009, 10:40 Delegate Jeff said...

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

Tue 24 Nov 2009, 11:39 Trainer Stephen said...

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.

Excel tip:

Find cells that match a format

In Excel you may wish to find cells that contain a specific formatting such s colour.

Select Edit > Find, click on Options and then Format...choose the formatting that you want found and click on OK

Choose one of the Find buttons to find.

View all Excel hints and tips

Logical Functions (i think)

Logical Functions (i think)

RE: Logical Functions (i think)

Attached files...

Excel articles

Excel tip:

Find cells that match a format