The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

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

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Logical Functions (i think)

Resolved · Urgent Priority · Version 2003

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

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

For upcoming training course dates see: Pricing & availability

ReplyTue 24 Nov 2009, 11:39Trainer 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 articles

· Data Validation In Excel: Not As Daunting As It Sounds
· How To Use Slicers In Excel 2010
· How Small Businesses Profit from Outside Excel Training
· Utilise the web's information banks with Microsoft Excel
· How To Use Filtering In Excel 2010

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

Excel tip:

Remove unused toolbar buttons

Are there buttons on your Excel toolbars that you never use? Remove them from the toolbar by doing the following:

1. Go to Tools - Customise - Commands.
2. Select the toolbar button you wish to remove, then use your mouse to drag and drop the button into the Excel window. When you release your finger from the mouse, the button will disappear.

View all Excel hints and tips

How could I alternate formats between questions and answers without having to paint each individually.

» Forum post: Word

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions