Thread: Return 0.00 if Neg.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
  
Posts: 2,722
Default Return 0.00 if Neg.
=MAX(0,SUM(D20-D19))
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Canon" wrote:

Excel 2007
I am using a very simple formula;
cell D22=SUM(D20-D19)
But if the sum of the above formula is negative, I need to show 0.00 in cell
D22
Reply With QuoteReply With Quote