Naming an IF statement

[Elijah]

Hi,

I have an 3-line IF statement which I'd like to name. I'v tried a copy
an paste of the formula into the 'name box' but it doesn't work.

Is there an easy way to create a named formula which refers to a
fairly long IF statement, without retyping it?

Any help appreciated

Elijah

 

[keepitcool]

select the text in the formula bar.
ctrl-c

then goto insert/names/define name
type a name
paste the formula in the refers to box at the bottom.

use F2 inside the the refto box to toggle editing/pointing.


keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >

 

[Paul Corrado]

Elijah,

You need to use

Insert|Name|Define and copy the formula into the Refers to area.

Also, if you post the formula it is possible that someone can help to
eliminate the nested IF's.

PC

 

[Elijah]

Thats what I thought I could do - simply copy the formula from the formula
bar, then define a name and paste it ==> but for some reason it won't work.
Maybe my function is too long. One of the IF statements is:

=IF($H$446=TRUE,IF($H$450=TRUE,B90*B95*$I$453/1000,IF(B95>$I$458,$J$458*$I$4
58*B90/1000+(B95-$I$458)*$J$459*B90/1000,$J$458*B95*B90/1000)),IF($H$450=TRU
E,B90*B95*$I$453/1000,IF(B95>$I$458,$J$458*$I$458*B90/1000+(B95-$I$458)*$J$4
59*B90/1000,$J$458*B95*B90/1000)))

It's based on a couple of form checkboxes which the user can select.

I basically have four variations of the above formula and what I'd like to
do is create another if statement like: IF(A1="Aa",Use
formula1,IF(A1="Bb",formula2,IF(A1="Cc",formula3,IF(A1="Dd",formula4,""))))

Is there a another way to reference a formula - I think I read post a while
back that you could copy-paste the forumla text in a another cell and
reference to it somehow..

I think I'm out of my depth here..

Thanks for the advice so far Paul & keepitcool - much appreciated. Do you
have any other suggestions

Elijah

 

[JohnI]

Elijah,

Just found a limitation on Names of 255 characters.

Your formula is 262 characters.

You'll have to split your formula up & use 2 Names, one inside the other.

regards,

JohnI