I have a similar problem! I want to say if there is a "y" in A2 then perform
a calculation on the value in A1 otherwise do nothing. I tried
=IF(A2=y,((A1/100)*17.5),""). Any ideas - I am a bit of a formula novice so I
need answers in simple terms.
"Nick Hodge" wrote:
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.