if function

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » IF function

IF function

resolvedResolved · Low Priority · Version 2007

Dympna has attended:
Excel Advanced course

IF function

How do you link IF formulas together?

Edited on Sat 5 Apr 2008, 14:33

RE: IF function

Hi Dympna, Thank you for the post and welcome to the forum, in answer to your question, Linking or Nesting IF formulas can be accomplished like this:
In Excel you can nest up to 7 functions, the IF function is a 'What If' operation, which checks a particular item, if the condition is True it will return one result, if False another. When we create a nested IF, it is usual that we know the answer to the True portion but are searching for the result from the False portion.
So if the syntax for a single IF is: =IF(arguement,True,False) then the syntax for a nested IF will be =IF(arguement,True,IF(arguement,True,IF(arguement,True,False))) remembering to close as many parenthesis as you have opened. To look at this as an actual formula we may be considering if cell A1 is between a particular set of values and applying a calculation dependant upon the value; so in cell B1 we could create the formula; =IF(A1>100,A1*10,IF(A1>75,A1*7.5,IF(A1>50,A1*5,0))) which would then decide if A1 was greater than the value given in this case 100,75 or 50 and in each case would multiply the value by 10,7.5 or 5; dependant upon the value found, if however the value was below 50 then nothing would be undertaken. I hope that helps, best regards Pete.

 

Training courses

 

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.


 

Excel tip:

Counting Non Number Cells (Text)

If you try to use the COUNT FUNCTION =COUNT(Cell range)with a range of cells with numbers and or containing text fields you wil find that that the text cells will be excluded from the the count. If you want to include them try the the COUNTA FUNCTION =COUNTA(Cell range). This counts both text and number cell values.

View all Excel hints and tips


Server loaded in 0.09 secs.