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 functions
If functions
Resolved · Low Priority · Version 2007
Fri 12 Aug 2011, 16:48Delegate Sarah said...
Sun 14 Aug 2011, 23:56Trainer Doug said...
RE: if functions
Hi Sarah
Sorry for late reply.
Multiple IF functions...
For example suppose you want to use multiple 'if' functions to tell you whether a temperature is hot if above 25C, warm if above 15C, or cold if 15C or below.
A B
Temp Hot/Warm/Cold Result
26 =IF(A2>25,"Hot",IF(A2>15,"Warm","Cold")) Hot
14 Cold
23 Warm
Create this example then copy the function from B2 to B3:B4 to see the result.
For more results, eg freezing if below 0C, replace "Cold" with IF(A2>0,"Cold","Freezing")
Sun 21 Aug 2011: 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. |
