Add word to cell containing IF formula and numeric value

[Spoontang]

Hello,

I have a sheet for pricing variations of a product. Some variations are held in stock, some aren't and some are special order.

This is part of the calc:

IF(B14=63,"NO Stock",IF(B14=65,A14*C14*1044,IF(B14=80,"NO Stock",IF(B14=85,A14*C14*1184,IF(B14=100,"NO Stock",

65 and 85 will return a value. 85 is a special order for this variant, so I want it to return the value and add SO in the cell. Something like "1,087 SO", so the item isn't quoted straight out as you are prompted it is a special order in part.

The ways I have tried returns that I'm asking it to do to many things. Do I need to add another cell to capture this?

Thanks,

 

[Mazbuka]

Do you mean something like this?

IF(B14=63,"NO Stock",IF(B14=65,A14*C14*1044,IF(B14=80,"NO Stock",IF(B14=85,A14*C14*1184&" SO",IF(B14=100,"NO Stock",

 

[Spoontang]

Yep, exactly like that.

Thanks Mazbuka, much appreciated.