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
|