Thread: If then with wrong return value
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default If then with wrong return value
=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)))))
--
David Biddulph

"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,))))) )


Reply With QuoteReply With Quote