I need a formula to say if(A1<-1,"B",if(A11,"S") but if it is between -1 and
1 then "---" or if it is = --- then also ---.

Any ideas? Thank you

Hi Matt

=IF(A1<-1,"B",IF(A11,"S",IF(AND(A1<1,A1-1),"---",IF(A1="---","---"))))
You don't say what happens when it equals 1 or -1. If you need that, you
can change the AND part to <= and =. Also, you do not specify what happens
if all conditions evaluate to false. To cater for that, I would put a comma
before the first clsing bracket, and add in something like "" to let the cell
evaluate to nothing
--
ve_2nd_at. Randburg, Gauteng, South Africa


"Matt" wrote:

I need a formula to say if(A1<-1,"B",if(A11,"S") but if it is between -1 and
1 then "---" or if it is = --- then also ---.

Any ideas? Thank you