Trying to change a certain column of row cells to "0.00" 0.00
So lets say H11,H20,H30 have the word "D (Checking)" in it. Then in cells E11,E20,E30 would like to change the cell values to 0.00
I can do an =IF formula in another column and get the results, but im trying to change what i need changed in Column E because i need to leave certain cells alone.
Think i would need to do a small macro so it changes only the cells i indicate above.
Looks like:
Excel 2016 (Windows) 32 bit
What I need it to look like:
Excel 2016 (Windows) 32 bit
Column E cell changed to 0.00
Any help thanks
So lets say H11,H20,H30 have the word "D (Checking)" in it. Then in cells E11,E20,E30 would like to change the cell values to 0.00
I can do an =IF formula in another column and get the results, but im trying to change what i need changed in Column E because i need to leave certain cells alone.
Think i would need to do a small macro so it changes only the cells i indicate above.
Looks like:
Excel 2016 (Windows) 32 bit
E | F | G | H | |
---|---|---|---|---|
9 | $ 1,352.93 | 0 | ||
10 | $ 869.67 | 0 | ||
11 | $ 1,004.06 | 0 | D (Checking) | |
12 | $ 548.58 | 1623 | ||
13 | $ 1,114.32 | 21608 |
Sheet: Formulas |
What I need it to look like:
Excel 2016 (Windows) 32 bit
E | F | G | H | |
---|---|---|---|---|
9 | $ 1,352.93 | 0 | ||
10 | $ 869.67 | 0 | ||
11 | $0.00 | 0 | D (Checking) | |
12 | $ 548.58 | 1623 |
Sheet: Formulas |
Column E cell changed to 0.00
Any help thanks