I need help with writing a formula. I need to have formula that is generated from a set of 7 results. the resukts show if something has improved or gotten worse.
if 0-2, improve, then have to sell
if 2-5 improve then have to hold
if 5-7 improve then have to buy
I have tried: =if("Improved"<2,"SELL",IF("Improved"<5,"HOLD","BUY"))
but it only works for 2 of the options and seems to always miss out one of the actions.
can anybody help with the actual formula, ive tried using the formula wizard on excel but no joy...thanks
2006-12-02
03:18:44
·
8 answers
·
asked by
mel
1
in
Software