Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
IF/OR Functions Together?
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
IF/OR Functions Together?
=IF(A110,"Greater",IF(A1<10,"Less","Ten"))
The above formula is similar to what you want. it lookas at the value in Cell A1. If it is greate than then it returns Greater. If Ai is less than 10 then it returns "Less". If it = 10 then it returns "Ten" HTH "simsjr" wrote: 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
IF/OR Functions Together?
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
IF/OR Functions Together?
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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
IF/OR Functions Together?
=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. |
#6
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. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
IF/OR Functions Together?
have used nested if's in excel formla. Not in VBA. Not knowledgeable. Is
there a way to used nested ifs and have it evaluate when leaving row. Useing workbook event executes on target cell. Need to have other things happen dependent on entry in other cells of row. would like to have evaluation also if target cell was blank when leaving row. Maybe I am asking to much? Thanks "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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert cell formula functions to code functions | Excel Discussion (Misc queries) | |||
formula/functions for average and if functions | Excel Worksheet Functions | |||
efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
Nesting functions in the functions dialog box | Excel Worksheet Functions | |||
excel functions and User defined functions | Excel Programming |