View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
day[_2_] day[_2_] is offline
external usenet poster
 
Posts: 7
Default How to get rid of #Value!

I have this formula typed in for a cell. It gives me the result I
need, but when there's no input the #Value! shows up. How would I
change up the formula so the errors don't show?

=IF(B22<0,B22,IF(B23-B22,"$0.00",B23-B22))

cheers,

day