Thread: More than one "if" in a cell
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten Niek Otten is offline
external usenet poster
  
Posts: 3,440
Default More than one "if" in a cell
=IF(H7<1,0,IF(H739,D7+(F7*H7),C7+(E7*H7)))

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Buggelsgaard" wrote in message
...
I would like to put all these functions into one cell:
IF H7 is less than 1, then the result is 0.
IF H7 is 1-39, then the result is C7+(E7*H7).
IF H7 is more than 39, then the result is D7+(F7*H7).

How would this formula be created?

Reply With QuoteReply With Quote