Thu 24 Jan 2008, 09:51Delegate John-paul said...
John-paul has attended:
Excel Intermediate course
IF statements
Is there an easy way to get to grips with using multiple IF statements i.e. is there a working example out there that can show me how to string lots of them together?
Fri 25 Jan 2008, 10:48Delegate Paul said...
RE: IF statements
=IF(A1>100,"high",IF(A1=100,"exact",IF(A1<100,"low","")))
This illustrates how to use multiple if statements together.
if the result is true, then do one thing, otherwise move onto the next thing and so on.
remember to put a close bracket for every open bracket.
