| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Leave Blank If No Data
George, assuming the case is that sometimes you have E,F, and G with no data,
this formula should help: =IF(COUNTA(E2:G2)0;(E2+F2-G2);" ") Regards, Emece.- "George" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Leave Blank If No Data
Emece - If tried to enter the formula in column H and I get an error message
that it contains a typo, won't except it. George "Emece" wrote: George, assuming the case is that sometimes you have E,F, and G with no data, this formula should help: =IF(COUNTA(E2:G2)0;(E2+F2-G2);" ") Regards, Emece.- "George" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Leave Blank If No Data
=IF(COUNT(E2:G2)0,E2+F2-G2,"")
"George" wrote: Emece - If tried to enter the formula in column H and I get an error message that it contains a typo, won't except it. George "Emece" wrote: George, assuming the case is that sometimes you have E,F, and G with no data, this formula should help: =IF(COUNTA(E2:G2)0;(E2+F2-G2);" ") Regards, Emece.- "George" wrote: 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Leave Blank If No Data
This works - Thanks a lot
"Teethless mama" wrote: =IF(COUNT(E2:G2)0,E2+F2-G2,"") "George" wrote: Emece - If tried to enter the formula in column H and I get an error message that it contains a typo, won't except it. George "Emece" wrote: George, assuming the case is that sometimes you have E,F, and G with no data, this formula should help: =IF(COUNTA(E2:G2)0;(E2+F2-G2);" ") Regards, Emece.- "George" wrote: 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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Leave Blank If No Data
Try using commas instead of the semicolons:
=IF(COUNTA(E2:G2)0,E2+F2-G2,"") I removed the ()'s from the E2+F2-G2 portion and I removed the space from the final string. George wrote: Emece - If tried to enter the formula in column H and I get an error message that it contains a typo, won't except it. George "Emece" wrote: George, assuming the case is that sometimes you have E,F, and G with no data, this formula should help: =IF(COUNTA(E2:G2)0;(E2+F2-G2);" ") Regards, Emece.- "George" wrote: 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 -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Leave Blank If No Data
This Works Too - Thanks a lot !
George "Dave Peterson" wrote: Try using commas instead of the semicolons: =IF(COUNTA(E2:G2)0,E2+F2-G2,"") I removed the ()'s from the E2+F2-G2 portion and I removed the space from the final string. George wrote: Emece - If tried to enter the formula in column H and I get an error message that it contains a typo, won't except it. George "Emece" wrote: George, assuming the case is that sometimes you have E,F, and G with no data, this formula should help: =IF(COUNTA(E2:G2)0;(E2+F2-G2);" ") Regards, Emece.- "George" wrote: 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 -- Dave Peterson . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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) | |||
Hybrid Mode
