nested functions exceeding lmit

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all, wondering if someone can help me

I've seen previously on this site a reference to this page:

http://www.cpearson.com/excel/nested.ht
This staement appears about a third the way down

First, we'd create a named formula called OneToSix, referring to the formula
=IF(Sheet1!$A$4=1,11,IF(Sheet1!$A$4=2,22,IF(Sheet1!$A$4=3,33
IF(Sheet1!$A$4=4,44,IF(Sheet1!$A$4=5,55,IF(Sheet1!$A$4=4,44
IF(Sheet1!$A$4=5,55,IF(Sheet1!$A$4=6,66,FALSE)))))))

Where and how to I create this named formula

Thanks in advanc

Alb
 
Hi

As values in A4 are 1,2,3, .... , you can use the formula
=CHOOSE($C$14;11;22;33;44;55)
instead.
And as all responses follow a certain muster, then in your case the formula
may be even more simpler
=$C$14*11

You can create a named formula like named range: Insert.Name.Define - enter
name into field at top of window - enter the formula at bottom of window.
 
Where and how to I create this named formula?

In the Define Name dialog. Use CTRL-F3 to access it. Enter "OneToSix"
(without the quotes) in the Names In Workbook box. The formula goes in the
Refers To box.

Chip does cover this ; nearer the top of the page, there's a "defined name"
link. Go there and check the paragraph beginning "To create a new Named
Range".

Rgds,
Andy
 
Back
Top