Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Leave Blank if No Value | Excel Discussion (Misc queries) | |||
Leave cell blank if no data | Excel Discussion (Misc queries) | |||
Do not show lack of data as a zero on graph lines, leave blank | Charts and Charting in Excel | |||
Leave cell data (IF(ISNA(VLOOKUP) is TRUE instead of returning blank (" ") or #NA | Excel Worksheet Functions | |||
leave cell blank | Excel Discussion (Misc queries) |