I have a spreadsheet with many complex formulas. Is there a way to translate
those formulas into laymens terms?

Thanks,

Mendz

Use named ranges for the formula elements. If you already have your
formulas, create the named ranges then highlight the area where your
formulas are and choose apply. If you haven't created the formulas
yet, create the named ranges and use your mouse to click on the cells
rather than typing the cell address.


--
Chris Berry
------------------------------------------------------------------------
Chris Berry's Profile: http://www.excelforum.com/member.php...o&userid=36165
View this thread: http://www.excelforum.com/showthread...hreadid=574411

Chris,

I highlighted 3 sells and named them "Purchasing", but I don't see where I
can apply that name to formula in the fourth cell.

Sorry, but I'm a novice spreadsheet user, at best.

Thanks,

Mendz

"Chris Berry" wrote:


Use named ranges for the formula elements. If you already have your
formulas, create the named ranges then highlight the area where your
formulas are and choose apply. If you haven't created the formulas
yet, create the named ranges and use your mouse to click on the cells
rather than typing the cell address.


--
Chris Berry
------------------------------------------------------------------------
Chris Berry's Profile: http://www.excelforum.com/member.php...o&userid=36165
View this thread: http://www.excelforum.com/showthread...hreadid=574411

the idea of naing cells is to make your formulas more "descriptive.An example
is instead of =A2/A3 name a2 annual_sales and A3 months and you can see
exactly what that formula is doing.If your formulas already exist and written
by someone else it may be difficult but may still help.Once named those names
show up every where.EG =if(annual_sales/monthslast_year/month,"party","more
sales")
--
paul

remove nospam for email addy!



"Mendz5" wrote:

Chris,

I highlighted 3 sells and named them "Purchasing", but I don't see where I
can apply that name to formula in the fourth cell.

Sorry, but I'm a novice spreadsheet user, at best.

Thanks,

Mendz

"Chris Berry" wrote:


Use named ranges for the formula elements. If you already have your
formulas, create the named ranges then highlight the area where your
formulas are and choose apply. If you haven't created the formulas
yet, create the named ranges and use your mouse to click on the cells
rather than typing the cell address.


--
Chris Berry
------------------------------------------------------------------------
Chris Berry's Profile: http://www.excelforum.com/member.php...o&userid=36165
View this thread: http://www.excelforum.com/showthread...hreadid=574411