1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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"))))))))))))))))

submitted by /u/Frost___Warden
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com
#cloud-based spreadsheet applications
#financial modeling with spreadsheets
#AI formula generation techniques
#Excel compatibility
#Excel alternatives for data analysis
#IF Conditions
#cell formula
#output value
#range value
#syntax
#B4
#Negative
#Neutral
#Positive
#Abnormal
##ERROR!
#manual formula
#comparison operators
#output based on input