Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If, Then Statements
Will Excel allow you to do an if/then statement which evaluates a value and
applies a different equation depending on what that value is? i.e. If B1<5, then use this equation: =(5/100*A1-(A1*B1/100))/(5/100) or simpler ... If B1<5, then C1 or If B1=the numbers 5-10, then D1(formula) If B110, then E1(formula) Any help would be much appreciated!! Thanks!!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If, Then Statements
Dave,
I've also been completely stuck with a coversion chart and am not sure what type of "IF" or "LOOKUP" might solve my problem. I need to have a valur replace a grade entered. However, that grade may either be numberical or not. For example: if grade is entered as 94 the it shoukld be replace as 4.0, if it's entered as A it should be replaced with 4.0. Can you offer a suggestion? "Dave F" wrote: Yeah, you can do that: =IF(B1<5,C1,IF(AND(b54,B5<11),D1,E1) Dave -- Brevity is the soul of wit. "RS" wrote: Will Excel allow you to do an if/then statement which evaluates a value and applies a different equation depending on what that value is? i.e. If B1<5, then use this equation: =(5/100*A1-(A1*B1/100))/(5/100) or simpler ... If B1<5, then C1 or If B1=the numbers 5-10, then D1(formula) If B110, then E1(formula) Any help would be much appreciated!! Thanks!!! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If, Then Statements
You want something like:
=if(isnumber(a1),vlookup(a1,Sheet2!A:B,2,true),vlo okup(a1,Sheet2!C:D,2,false)) -- Regards, Fred "Angie" wrote in message ... Dave, I've also been completely stuck with a coversion chart and am not sure what type of "IF" or "LOOKUP" might solve my problem. I need to have a valur replace a grade entered. However, that grade may either be numberical or not. For example: if grade is entered as 94 the it shoukld be replace as 4.0, if it's entered as A it should be replaced with 4.0. Can you offer a suggestion? "Dave F" wrote: Yeah, you can do that: =IF(B1<5,C1,IF(AND(b54,B5<11),D1,E1) Dave -- Brevity is the soul of wit. "RS" wrote: Will Excel allow you to do an if/then statement which evaluates a value and applies a different equation depending on what that value is? i.e. If B1<5, then use this equation: =(5/100*A1-(A1*B1/100))/(5/100) or simpler ... If B1<5, then C1 or If B1=the numbers 5-10, then D1(formula) If B110, then E1(formula) Any help would be much appreciated!! Thanks!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple IF statements or a better method ? | Excel Discussion (Misc queries) | |||
2 IF Statements not mutually exclusive | Excel Discussion (Misc queries) | |||
UDFunctions and nested If-the-else statements | Excel Worksheet Functions | |||
Linking two IF statements together | Excel Discussion (Misc queries) | |||
Nested IF statements | Excel Worksheet Functions |