what is wrong with my if else statement

[jennxf]

=IF(F2>0.5,'positive', IF(F2<-0.3, 'negative', 'neutral'))

 

[pjmorris]

why do you think it is wrong? it will return 'positive' if F2 is greater than 0.5, it will return 'negative' if F2 is less than -0.3, and 'neutral' in other circumstances. You might need to change the quote marks to: ""

 

[azumi]

Change to:

=IF(F2>0,'positive', IF(F2<0, 'negative', 'neutral'))