| 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 |
| 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 | |||
Threaded Mode
