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 » IF
IF
Resolved · Low Priority · Version 2007
Thu 19 Mar 2009, 16:24Delegate Priya said...
Mon 23 Mar 2009, 10:42Trainer Simon said...
RE: IF
Hi Priya,
Thank you for your question.
You test a cell against another cell or value and if that condition is met, define a true answer and finally a False answer.
The IF function consists of 3 arguments:
=IF(Condition or logical test, True, False)
The Condition or Logical test could be A1>23000, followed by a true answer of "Yes" and a False answer of "No".
I hope this answers your question.
Regards
Simon
Mon 30 Mar 2009: Automatically marked as resolved.
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:Selecting your working rangeIn excel if you have an area you want to highlight, press Ctrl + * or Ctrl+Shift+8 (to get the *). This will select your working range. |
