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

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

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

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

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

Nested IF / greater than / less than help
 

Some error checking on h2
=IF(AND(ISNUMBER(H2),LEN(TRIM(H2))0),H2*IF(H2=35 ,1.75,IF(H25,1.85,2)),"")

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Don Guillett" wrote in message
...

=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