defining global function to be used in multiple cells

[cerr]

Hi There,

I'm wondering if I'm able to create a global function something like
light*correction/100
and then use this function in multiple cells which are to be displayed
in a graph and when i change the formula, my graph would be updated
with the new values. How do i do that? I already defined names for my
columns so i actually can use e.g. "Light" and "correction" instead of
A1:Axxx and B1:Bxxx ...

Thanks for hints and suggestions!

 

[Pete_UK]

Put your cursor on row 1 then click on Insert | Name | Define (XL2003
or earlier) or Formulas | Define Name in the Defined Names group
(XL2007 or later). In the dialogue box fill in the Name that you want
to use (eg Result) and then in the Refers to box you can enter the
formula:

=Light*correction/100

then click OK.

Then you should be able to use:

= Result

and copy this down.

Hope this helps.

Pete