View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
George George is offline
external usenet poster
 
Posts: 347
Default Leave Blank If No Data

I have two columns of dollar amounts I want to add, E & F,and subtract the
third, G, and the results in column H.

So I entered the formula =Sum(E2+F2-G2) down column H and that works but it
automatically enters $0.00 down the column.

So I entered the following formula down column H and that got rid of the
$0.00 unless there is a value in E, F or G but if the results just happens to
total $0.00 then column H remains blank, I don't want that.

=IF(E2+F2-G2<0,(E2+F2-G2),"")

How can I tweak this formula to leave column H only blank when there isn't
anything entered.

Thanks