Naming an IF statement

  • Thread starter Thread starter Elijah
  • Start date Start date
E

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
 
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 >
 
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
 
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
 
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
 
Back
Top