View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default if the # is a negative #, then show 0

This could get you into difficulties if you intend to perform further
calculations on an answer that is now incorrect but here you go

=IF(B14-A14<0,0,B14-A14)

assumes you are subtracting B14 from A14. Modify to suit.

" wrote:

I cant seem to figure out how to make a formula that when it performs its
calculation and the answer is a negative #, i want it to just show "0".
Is it a IF command?

thanks