IF THEN STATEMENT

M

Matt

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

Any ideas? Thank you
 
K

Kassie

Hi Matt

=IF(A1<-1,"B",IF(A1>1,"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
 
Top