Thread: Nested If help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JoeA2006 JoeA2006 is offline
external usenet poster
  
Posts: 7
Default Nested If help
I am getting #Name? using this formula

=iif(O455<0,0,(IF(N4550,(P455*M455),0)),((N455*M4 55)-(O455*M455)))
I want to the cell to be 0 if the calculations are negative.
Thanks

Reply With QuoteReply With Quote