How to get Excel to calculate
 

How can I get Excel to calculate a selected range of columns based on another
column?-
brightstar

How to get Excel to calculate
 

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.

" wrote:

How can I get Excel to calculate a selected range of columns based on another
column?-
brightstar

How to get Excel to calculate
 

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

--
Regards,
Tom Ogilvy


" wrote in
message ...
How can I get Excel to calculate a selected range of columns based on
another
column?-
brightstar

How to get Excel to calculate
 

Thanks for your reply. I would like to use Data Validation for multilple
columns that is based on another column.
--
brightstar


"Tom Ogilvy" wrote:

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

--
Regards,
Tom Ogilvy


" wrote in
message ...
How can I get Excel to calculate a selected range of columns based on
another
column?-
brightstar