Use two nested IFs

=IF(Condition1,X,IF(Condition2,Y,Z))

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS

"simsjr" wrote in message
...
Hello,

I need to build a formula that basically says, "If condition 1 is true,
then
perform x calculation. If condition 2 is true, then perform y calculation.
If
neither condition is present, perform calculation z."

Anyone know how to do this? I thought maybe using IF/OR together would
help,
but I'm a little stumped.