Hello there,
There is an IF function in Excel.
=IF(Condition,True,False)
For Example:
If a customers' balance is in cell A1 then,
=IF(A1>0,"Credit","Debit")
You can also add nested IFs, eg.
If a pupils score is in A1 then,
=IF(A1>80,"Excellent",IF(A1>50,"Pass","Fail"))
You keep adding Conditions and Trues until the end when
you add the False.
You can have upto 7 nested IFs.
Remember to start with the highest first as Excel looks
at the conditions in order. I.E. if the nested IF above
was created like:
=IF(A1>50,"Pass",IF(A1>80,"Excellent","Fail"))
Anyone with over 50 will get Pass even if they have over
80 as a condition has already been met.
I hope this helps
Judith
