New To Excel - Question

[Newbie28]

I am very new to Excel and have a question regarding a formula. Here is the formula I am working with
=IF(SL="YES","NONE",110000&13&"-"&IF(LENGTH<20.1,233,IF(LENGTH<24.1,287,IF(LENGTH<28.1,335,IF(LENGTH<32.1,383,IF(LENGTH<35.1,419,IF(LENGTH<40.1,479,539)))))))

I have been asked to change the formula to "Length Minus (2)".

How and where in the formula do I do this?
Thank You

 

[GlennUK]

I'd guess you'd replace all LENGTH with (LENGTH-2)

 

[Newbie28]

Thank You, but it didn't work.

 

[GlennUK]

Show the formula that you have now, and explain what you mean by "it didn't work".

 

[Newbie28]

Glenn,
11000013-479 is the complete component number. When I put the Length-2 as you suggested, it changes the last part of the component number from 479 to 419. The 479 needs to remain constant.
Thank You.

 

[GlennUK]

Glenn,
11000013-479 is the complete component number. When I put the Length-2 as you suggested, it changes the last part of the component number from 479 to 419. The 479 needs to remain constant.
Thank You.

According to the formula the component number is dependent on the LENGTH, so wouldn't you expect it to change if your comparisons change? Maybe you'd better explain the logic of what you are trying to do, and then maybe someone may be able to help in a better way.