hide result of formula until criteria is added

December 18, 2012 at 17:12:17
Specs: Windows 7
If I have 3 rows in col. A , with a formula in B3 "=A3+B1"
A B C D E F G H I J

1. 75 20
2. 50
3. 30 50
...and I add amount in B1 as 20, the result is going to be 50. NOW, I want to copy the same formula in B3 to the rest of the columns...C3,D3,E3, etc. BUT I don't want the total to show "50" in all the colums until I fill in the cells C1,D1,E1,F1, etc. Thanks!


See More: hide result of formula until criteria is added

Report •


#1
December 18, 2012 at 17:31:30
Hi

It's not clear what you want C3,D3,E3 to produce. If you want C3 to be
A3+C1 and D3 to be A3+D1 then your formula in B3 should be

=if(B1<>"",$A$3+B1,"")

And then copy it across.

If that's not what you are looking for it would be helpful if you posted more data and highlighting what the inputs and results are.


Report •
Related Solutions


Ask Question