98.8% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft+excel+training - IF statements
microsoft+excel+training - IF statements
Resolved · Low Priority · Version Standard
Beth has attended:
Excel Intermediate course
Excel Advanced course
IF statements
what is an if statement and how do i create one?
RE: if statements
The IF function is based on a true or false situation, for example
=IF(A1>100, "Above target", "Under target")
dependent on whether the first condition (A1>100) is true the function will reveal the word Above target, and if is not true it will reveal the word Under target.
You have to put speech marks in if you want to reveal text, however if you want to put numbers you can leave the speech marks out.
For example
=IF(A1<1000, 20, 10)
So this would be interpreted as if the contents of A1 were less than 1000 it will give the number 20(i.e if the condition A1<1000 were true), if not it will give the answer 10.
Hope that helps, if there is anything specific you need to know get back to me
Thanks
Tracy
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:Converting an American date format to European using FormulaExcel depending on your local setting will only pick up date values of the dd mmm yyyy oders as date type. If you import data from various sources including America their date order is different with data value in mmm dd yyyy, excel can only treat it as text indicated by left aligning it. To overcome this you have to do the the following. |