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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Nested IF / greater than / less than help
Try it this way...
=IF(H2<=5,2*H2,IF(H2<35,1.85*H2,1.75*H2)) Rick "Tobey" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Nested IF / greater than / less than help
Try this
=IF(H2<=5,H2*2,IF(H2<35,H2*1.85,H2*1.71)) Mike "Tobey" wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Nested IF / greater than / less than help
=h2*if(h2=35,1.75,if(h25,1.85,2)) -- Don Guillett Microsoft MVP Excel SalesAid Software "Tobey" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Nested IF / greater than / less than help
oops,
I meant =IF(H2<=5,H2*2,IF(H2<35,H2*1.85,H2*1.75)) "Mike H" wrote: Try this =IF(H2<=5,H2*2,IF(H2<35,H2*1.85,H2*1.71)) Mike "Tobey" wrote: 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 |
Reply |
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 |