# Dragging formula to add two columns, but need to show blank when other cell is blank

1. ## Dragging formula to add two columns, but need to show blank when other cell is blank

Evening all -

I'm new to the forum and a standard user in excel, certainly not advanced. I am having an issue where I have the following:

A5 = 50.00 B5 = A5
A6 = - aka 0 B6 = B5+A6

Hope the above makes sense. I've tried a few formulas online that I have found online, but no success. When I have 0 entered in A6 I am getting the value of B5 in cell B6. I'd like to get that to show 0 until there is a value in A6.

Is this possible or would I need to manually drag the formula "=B5+A6" down each time to cells in column B?

2. ## Re: Dragging formula to add two columns, but need to show blank when other cell is blank

In B6 type =IF(ISNUMBER(A6),B5 +A6,0)

3. Originally Posted by alansidman
In B6 type =IF(ISNUMBER(A6),B5 +A6,0)
Thank you for your reply. If I have \$50.00 in B5 and in A6 I have \$0.00 then B6 is showing \$50. Only if I delete any values in A6 will the formula show correctly. However, I need to show \$0 in A6 for budgeting purpose.

4. ## Re: Dragging formula to add two columns, but need to show blank when other cell is blank

=if(a6=0,0,if(isnumber(a6),b5+a6,0))

5. Originally Posted by alansidman
=if(a6=0,0,if(isnumber(a6),b5+a6,0))
Awesome! This worked perfect! Thank you so much.

6. ## Re: Dragging formula to add two columns, but need to show blank when other cell is blank

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1