Thread: How do you Combine Two IF formulas
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ardy Ardy is offline
external usenet poster
  
Posts: 136
Default How do you Combine Two IF formulas
The result I am after is in one cell, I need the formula to enter 150.00 if the calculation result is less ten 150.00[=IF((B5*M5)<150,150,(B5*M5))] and enter 500.00 if the calculation is greater than 500.00[=IF((B4*M4)500.01,500,(B4*M4))]

so the two IF will be in the same cell.
Reply With QuoteReply With Quote