Forum home » Delegate support and help forum » Microsoft Excel Training and help » If functions
|
|
|
The UK's most regular 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. |
If functions
Resolved · Low Priority · Version 2007
Reply Fri 12 Aug 2011, 16:48Delegate Sarah said...
For upcoming training course dates see: Pricing & availability
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.
|