Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel training - IF query
Resolved · Low Priority · Version Standard
Sarah has attended:
Excel Intermediate course
How do I make an IF function to categorise lists?
The IF function is based on a true or false scenerio, an example would be
=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
|
Excel tip:Wrapping Text in a Cell in an Excel 2010 WorkbookWhen you have a lot of text you want to put in a particular cell but you can't decrease the font size to fit because the text will then become ineligible, then manually wrap the text in a cell by simply pressing ALT+ENTER. |
We'll call during UK business hours
Server loaded in 0.08 secs.