Thread: How do you Combine Two IF formulas
View Single Post
  #1   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
I am trying to combine =IF((B5*M5)<150,150,(B5*M5)) and =IF((B4*M4)500.01,500,(B4*M4)). I can't seem to get the syntax correct, or may be it is not supported to do nested IF.
Can somebody help me on this.
Reply With QuoteReply With Quote