Thread: More than one "if" in a cell
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme[_3_] Bernard Liengme[_3_] is offline
external usenet poster
  
Posts: 1,104
Default More than one "if" in a cell
=IF(H7<1,0, IF(H739,D7+(F7*H7), C7+(E7*H7)))
or
=(H739)*(D7+(F7*H7))+(H7<39)*(H7=1)*(C7+(E7*H7))
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"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