| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF with Equal to or Greater than
Okay, what am I doing wrong? B3 and C3 are being added properly, but when it
gets to the IF function it will only add C3*.01 to that total regardless of how high I set the value in D3. =(B3+C3)+IF(D3=0.1,C3*0.01,IF(D3=0.2,C3*0.015,IF (D3=0.3,C3*0.02,IF(D3=0.4,C3*0.025,IF(D3=0.5,C3 *0.03))))) Thank you |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF with Equal to or Greater than
You have to invert your values - start with highest to lowest, rather
than the order you have it. IF D3 0.3, it is also true that it is 0.1 On May 1, 1:58*pm, sonicj wrote: Okay, what am I doing wrong? *B3 and C3 are being added properly, but when it gets to the IF function it will only add C3*.01 to that total regardless of how high I set the value in D3. * * =(B3+C3)+IF(D3=0.1,C3*0.01,IF(D3=0.2,C3*0.015,IF (D3=0.3,C3*0.02,IF(D3=0*.4,C3*0.025,IF(D3=0.5,C 3*0.03))))) Thank you |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF with Equal to or Greater than
Just to be more clear -
It sees the 0.1, recognizes that it is true before it even gets to the 0.3 IF statement and completes your equation based on that. On May 1, 2:05*pm, wrote: You have to invert your values - start with highest to lowest, rather than the order you have it. IF D3 0.3, it is also true that it is 0.1 On May 1, 1:58*pm, sonicj wrote: Okay, what am I doing wrong? *B3 and C3 are being added properly, but when it gets to the IF function it will only add C3*.01 to that total regardless of how high I set the value in D3. * * =(B3+C3)+IF(D3=0.1,C3*0.01,IF(D3=0.2,C3*0.015,IF (D3=0.3,C3*0.02,IF(D3=0**.4,C3*0.025,IF(D3=0.5, C3*0.03))))) Thank you- Hide quoted text - - Show quoted text - |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF with Equal to or Greater than
Perfect! Thank you.
=(B3+C3)+IF(D3=0.5,C3*0.03,IF(D3=0.4,C3*0.025,IF (D3=0.3,C3*0.02,IF(D3=0.2,C3*0.015,IF(D3=0.1,C3 *0.01))))) " wrote: You have to invert your values - start with highest to lowest, rather than the order you have it. IF D3 0.3, it is also true that it is 0.1 On May 1, 1:58 pm, sonicj wrote: Okay, what am I doing wrong? B3 and C3 are being added properly, but when it gets to the IF function it will only add C3*.01 to that total regardless of how high I set the value in D3. =(B3+C3)+IF(D3=0.1,C3*0.01,IF(D3=0.2,C3*0.015,IF (D3=0.3,C3*0.02,IF(D3=0Â*.4,C3*0.025,IF(D3=0.5, C3*0.03))))) Thank you |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF with Equal to or Greater than
Glad to be of service!
On May 1, 3:35*pm, sonicj wrote: Perfect! *Thank you. =(B3+C3)+IF(D3=0.5,C3*0.03,IF(D3=0.4,C3*0.025,IF (D3=0.3,C3*0.02,IF(D3=0*.2,C3*0.015,IF(D3=0.1,C 3*0.01))))) " wrote: You have to invert your values - start with highest to lowest, rather than the order you have it. IF D3 0.3, it is also true that it is 0.1 On May 1, 1:58 pm, sonicj wrote: Okay, what am I doing wrong? *B3 and C3 are being added properly, but when it gets to the IF function it will only add C3*.01 to that total regardless of how high I set the value in D3. * * =(B3+C3)+IF(D3=0.1,C3*0.01,IF(D3=0.2,C3*0.015,IF (D3=0.3,C3*0.02,IF(D3=0**.4,C3*0.025,IF(D3=0.5, C3*0.03))))) Thank you- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Greater Than/Equal To Formula | Excel Discussion (Misc queries) | |||
| Greater than or equal to (Plus or minus) | Excel Discussion (Misc queries) | |||
| First occurance greater than or equal to a specified value | Excel Worksheet Functions | |||
| GREATER OR EQUAL TO BUT LESS THAN Problem using Sumproduct | Excel Worksheet Functions | |||
| Vlookup but also equal to and greater than? | Excel Worksheet Functions | |||
Linear Mode
