98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel+course - IF function
excel+course - IF function
Resolved · Low Priority · Version Standard
Wed 23 Jan 2008, 09:47Delegate Shabby said...
Shabby has attended:
Excel Advanced course
IF function
I'd like to find out when it's appropriate to use the IF function.
Wed 23 Jan 2008, 16:58Delegate Paul said...
RE: IF function
the IF Function is the most flexible of functions available. It can be used in some way in almost every situation
=if(isblank(A1),"",A1) is a good one
=if(and(A1=1,B1>100),"On Target","Off Target"
loads of things you can do with the if statement
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Remove unused toolbar buttonsAre there buttons on your Excel toolbars that you never use? Remove them from the toolbar by doing the following: |
