|
Posted to microsoft.public.excel.programming
|
|
|
IF/OR Functions Together?
Excellent thank you!!!!
"Tom Ogilvy" wrote:
=IF(lower(A2)="y",(A1/100)*17.5,"")
--
Regards,
Tom Ogilvy
"Cookie" wrote in message
...
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.
|