Thread
:
Nested IF / greater than / less than help
View Single Post
#
6
Posted to microsoft.public.excel.programming
Don Guillett
external usenet poster
Posts: 10,124
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett