Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Make a cell blank?
Hello,
I'm trying to write a formula that depending on the contents of another cell, will either have a number or be blank. Basically, if a set of numbers is entered, compute their sum, but if not, sit there quietly rather than giving a zero and the "formula refers to empty cells" warning. I can use the ISBLANK function to test if a cell is blank, such as: =IF(ISBLANK(V35),"",SUM(Q35:V35)) This gives me almost what I want. If no value is entered in V35, the formula gives an empty string. But, the empty string isn't blank: if I want to make another conditional calculation based on that data, I can't use ISBLANK anymore. Is there an Excel function or name which gives a blank value? I tried NULL, but I get the #NAME! Error. TIA, Matt |
#2
|
|||
|
|||
Hi
try =IF(V35="","",SUM(Q35:V35)) -- Regards Frank Kabel Frankfurt, Germany "Matthew Leingang" schrieb im Newsbeitrag ... Hello, I'm trying to write a formula that depending on the contents of another cell, will either have a number or be blank. Basically, if a set of numbers is entered, compute their sum, but if not, sit there quietly rather than giving a zero and the "formula refers to empty cells" warning. I can use the ISBLANK function to test if a cell is blank, such as: =IF(ISBLANK(V35),"",SUM(Q35:V35)) This gives me almost what I want. If no value is entered in V35, the formula gives an empty string. But, the empty string isn't blank: if I want to make another conditional calculation based on that data, I can't use ISBLANK anymore. Is there an Excel function or name which gives a blank value? I tried NULL, but I get the #NAME! Error. TIA, Matt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C. | Excel Discussion (Misc queries) | |||
make a cell empty based on condition | Charts and Charting in Excel | |||
conditional formatting blank cell | Excel Discussion (Misc queries) | |||
Help with formula to make cell blank | Excel Worksheet Functions | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |