Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Functions
I'm trying to set up a cell with IF functions such as:
I want cell BG37 to multiply cell S11 by 18% if cell AA11 is <=30 or multiply cell S11 by 22% if cell AA11 is 30 but <91 or multiply cell S11 by 26% if cell AA11 91. Here is the formula I entered in cell BG37: =IF(AA11<=30,S11*0.18,IF(AA11=31<90,S11*0.22,IF(AA 1190,S11*0.26))) The 1st function works and the last function works but the 2nd function says FALSE if the value in AA11 is between 31 to 90. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Functions
something like
=if(aa1191,.26,if(aa1130,.22,.18))*s11 -- Don Guillett SalesAid Software "DirtTrux" wrote in message ... I'm trying to set up a cell with IF functions such as: I want cell BG37 to multiply cell S11 by 18% if cell AA11 is <=30 or multiply cell S11 by 22% if cell AA11 is 30 but <91 or multiply cell S11 by 26% if cell AA11 91. Here is the formula I entered in cell BG37: =IF(AA11<=30,S11*0.18,IF(AA11=31<90,S11*0.22,IF(AA 1190,S11*0.26))) The 1st function works and the last function works but the 2nd function says FALSE if the value in AA11 is between 31 to 90. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Functions
=IF(AA11<=30,S11*0.18,IF(AA11<=90,S11*0.22,S11*0.2 6)))
not checked ------------------------ means: =IF(AA11<=30,S11*0.18, else IF(AA11<=90,S11*0.22, else S11*0.26))) "DirtTrux" wrote in message ... I'm trying to set up a cell with IF functions such as: I want cell BG37 to multiply cell S11 by 18% if cell AA11 is <=30 or multiply cell S11 by 22% if cell AA11 is 30 but <91 or multiply cell S11 by 26% if cell AA11 91. Here is the formula I entered in cell BG37: =IF(AA11<=30,S11*0.18,IF(AA11=31<90,S11*0.22,IF(AA 1190,S11*0.26))) The 1st function works and the last function works but the 2nd function says FALSE if the value in AA11 is between 31 to 90. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I get Excel to determine the line curve formula without graph. | Excel Discussion (Misc queries) | |||
User-defined functions created in Excel 2000 fail in Excel 2003 | Excel Discussion (Misc queries) | |||
Database functions should use criteria in formula, as 1-2-3 does | Excel Worksheet Functions | |||
Are there functions that perform robust statistics in Excel? | Excel Worksheet Functions | |||
Visible rows and functions that work | Excel Worksheet Functions |