Changing Column Value Based on Another Column Value

**wvford** · 01-03-2019, 11:23 PM

Hi,

I am fairly new to excel and was hoping to get some help. I will try to explain the best I can on what I need.

I have two columns of numbers that I am calculating multiple formulas into different cells from. I am down to the very last thing I need to do and I am stuck. Here is an example on what I need.

So column B...formula uses columns A to calculate equation. Column A will be filled in throughout this year (one row for each week). So as of now Column B shows 0.00 if column A does not have a number listed. So I created a formula to hide the 0 which works and makes it look blank. But more I think about it, there is a chance that Column A will have a 0 in it once or twice this. Therefor Since the formula in Column B multiplies Column A, Column B will have a 0 and I want this 0 to show since Column A has a 0.

So long story short. If column A cell is blank, I need column B cell to also be blank. If column A has any number in it, 0 included, I need column B to perform the equation even if the answer is 0.

Quick example below: When column A has a 0 I need column B to do the equation which would also give an answer of 0 and I need this 0 to show in excel. When there is nothing written in Column A I need Column B to show blank... As of now column B still shows 0 in my excel sheet. I know that I can just erase the formula in column B and only add it when Column A has a number but I was hoping to have all the formulas completed so that I can lock down everything except for the numbers I need to put in later.

	Column A	Column B
Week 1	2	4
Week 2	3	6
Week 3	0	0
Week 4	4	8
Week 5
Week 6

Thanks

**FlameRetired** · 01-04-2019, 12:09 AM

Hello wvford. Welcome to the forum.

Before we get started:

As a new member you need to familiarize yourself with our forum rules. There aren't many of them and one of them is

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

**queuesef** · 01-04-2019, 12:11 AM

You need to use an IF statement. =if(A1<>"",formula,"") it reads: if there is something (NOT a blank) in A1, then do YOUR FORMULA, otherwise return a BLANK.

**AliGW** · 01-04-2019, 02:32 AM

As has been pointed out, your thread title was inadequate. As you are a new member, I have changed it for you this time by way of an example. Please note for future reference that we require more explicit thread titles. Thanks.