Need a book? Engineering books recommendations...

Return to index: [Subject] [Thread] [Date] [Author]

RE: Mathcad and or Excel

[Subject Prev][Subject Next][Thread Prev][Thread Next]
Ed, it is SO easy, you won't believe it.

In cell A1, type in "W="
In cell B1, enter 150
In cell C1, type "PLF"

O.K., now select cell B1.

move the mouse to the name box (upper left under the font name) and type in

Viola! you now have a named variable.

Go to any other cell and type in =W and 150 will appear. You can now use W
in any expression instead of a cell reference.

Cool, huh?


Bill Allen, S.E.
Laguna Niguel, CA

> I will disclaim that there may be some way to define
> variables in Excel, but
> I haven't figured it out.