Thread: How do you Combine Two IF formulas
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MyVeryOwnSelf[_3_] MyVeryOwnSelf[_3_] is offline
external usenet poster
  
Posts: 56
Default How do you Combine Two IF formulas
I am trying to combine =IF((B5*M5)<150,150,(B5*M5)) and
=IF((B4*M4)500.01,500,(B4*M4)).

There are four cases. Think about what result is needed in each case.

(B5*M5)<150 and (B4*M4)500.01
(B5*M5)<150 and NOT((B4*M4)500.01)
NOT(B5*M5)<150 and (B4*M4)500.01
NOT(B5*M5)<150 and NOT(B4*M4)500.01

OTOH, if the problem is actually all in one row, one way is:
=MAX(150,MIN(B4*M4,500))


Reply With QuoteReply With Quote