How can I get Excel to calculate a selected range of columns based on another column?- brightstar
D dimartin551 Nov 5, 2006 #1 How can I get Excel to calculate a selected range of columns based on another column?- brightstar
B Barb Reinhardt Nov 5, 2006 #2 I'm not sure what you are asking. Are you saying you want the value in column C to be calculated based upon Column B? Try something like this C2: =B2*2+3 If that's not what you are looking for, let me know.
I'm not sure what you are asking. Are you saying you want the value in column C to be calculated based upon Column B? Try something like this C2: =B2*2+3 If that's not what you are looking for, let me know.
T Tom Ogilvy Nov 5, 2006 #3 You can also use an if statement is the controlling column is not involved in the calculation in C! =if(B1<>"",existing formula,"") as an example
You can also use an if statement is the controlling column is not involved in the calculation in C! =if(B1<>"",existing formula,"") as an example
D dimartin551 Nov 6, 2006 #4 Thanks for your reply. I would like to use Data Validation for multilple columns that is based on another column.
Thanks for your reply. I would like to use Data Validation for multilple columns that is based on another column.
