| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to get Excel to calculate
How can I get Excel to calculate a selected range of columns based on another
column?- brightstar |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
| How do I get Excel to automatically calculate salaries actually received in financial year? | Excel Discussion (Misc queries) | |||
| how to calculate the hours and minutes in excel | Excel Discussion (Misc queries) | |||
| how to calculate surface area in excel chart | Charts and Charting in Excel | |||
Linear Mode
