Trying to formulate cell with multiple IF Conditions based on range
I'm trying to formulate a cell so that it outputs a value based on the number another cell has in it
C23 =IF(B4>2,"Negative") C23 =IF(B4>=2 but <7,"Neutral") C23 =IF(B4>=7 but <15,"Positive") C23 =IF(B4>=15,"Abnormal")
I feel like I'm really close to figuring out the syntax, but I'm struggling to figure out how to type out the range value with the (B4>=2 but <7) part
Alternatively I have tried doing it manually as a long formula and it keeps coming up as #ERROR!
=IF(B4=0,"Negative",IF(B4=1,"Negative",IF(B4=2,"Neutral",IF(B4=3,"Neutral",IF(B4=4,"Neutral",IF(B4=5,"Neutral",IF(B4=6,"Neutral",IF(B4=7,"Positive",IF(B4=8,"Positive",IF(B4=9,"Positive",IF(B4=10,"Positive",IF(B4=11,"Positive",IF(B4=12"Positive",IF(B4=13,"Positive",IF(B4=14,"Positive",IF(B4>=15,"Abnormal"))))))))))))))))
[link] [comments]
Want to read more?
Check out the full article on the original site