If then with wrong return value
The formula will return 3.4 for negative numbers.
Tyro
"Tyro" wrote in message
...
If the number in H8 is never negative then:
=IF(H8<=10,3.4,IF(H8<=20,2.7,IF(H8<=30,2.3,IF(H8<= 40,2,IF(H8<=80,1.8,1.5)))))
You cannot use H8=10<=20 This has to be expressed as AND(H8=10,H8<=20)
There are other formulas to do this too, but I wanted to show you with
IF's, the way you're trying to do it.
Tyro
"Clark" wrote in message
...
This If-Then will only return "0" or "3.4" depending upon the contents of
H8.
How do I modify it to give me the number I want based upon the contents
of
H8?
=IF(H8<=10,3.4,IF(H8=10<=20,2.7,IF(H820<=30,2.3, IF(H830<=40,2,IF(H840<=80,1.8,IF(H880,1.5,))))) )
|