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(A10,"Credit","Debit")
You can also add nested IFs, eg.
If a pupils score is in A1 then,
=IF(A180,"Excellent",IF(A150,"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(A150,"Pass",IF(A180,"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
-----Original Message-----
Can you do "IF...THEN..."formulas in EXCEL and How?
Thanks
Mari
.
|