"IF..THEN.."formulas
 

Can you do "IF...THEN..."formulas in EXCEL and How? Thanks
Mari

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
.

Hi

=IF(Condition,TrueAnswer,FalseAnswer)
An example:
=IF(OR(B2=0,B2="",A2=""),"",A2/B2)

--
When sending mail, use address arvil<attarkon.ee
Arvi Laanemets


"Mari P" <Mari wrote in message
...
Can you do "IF...THEN..."formulas in EXCEL and How? Thanks
Mari