| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Nested IF / greater than / less than help
I wrote this formula:
=IF(H2<=5,H2*2,IF(AND(H25,H2<35),H2*1.85,IF(H2=3 5,H2*1.75))) but it is taking H2 value: .72 and returning 1.26 (*1.75) instead of 1.44 (*1.44). The goal: IF H2 is less than or equal to 5, multiply by (*2). IF H2 is greater than 5 or less than 35, multiply by 1.85 IF H2 is greater than or equal to 35, multiply by 1.75 Thank you!!! Tobey |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nested Greater than or less than if statements | Excel Worksheet Functions | |||
| If formula: if A1 is greater than B1 and A1 is greater than zero.. | Excel Discussion (Misc queries) | |||
| Nested Greater than or less than Formula | Excel Discussion (Misc queries) | |||
| Nested If statement to find greater than but less than numbers | Excel Worksheet Functions | |||
| CountIf Greater Than/Find Greater Than | Excel Programming | |||
Threaded Mode
