IF Statement for 3 text values

[Eireangel]

Hi

I want to create a formula that will return 3 numerical values based on 3 different text values.
I've got the first part but can't figure it out for the rest
=IF(A4="Decrease", "-1")

If cell says "decrease" return value of -1
If cell says "same" return value of 0
If cell says "increase" return value of 1

Thanks in advance!

 

[etaf]

there a few ways to do this - BUT as you mentioned IF - we can use a Nested IF
IF works as IF ( TEST , IF TRUE DO THIS, IF FALSE DO THIS)
By nesting the example below - IF the ANSWER if FALSE we do another IF and so in

IF decrease then do -1 , if false - then TEST again with a different TEST , this time SAME if true do 0 if false - TEST again with a different test this time increase , if true 1 if FALSE then the value in A4 is FALSE and does not meet any of our criteria so far - so put Does not meet in the cell - we could just put "" and leave the cell blank

=IF(A4="Decrease", -1, IF( A4="Same", 0 , IF( A4 = "Increase", 1 , "Does not meet criteria" )))
NOTE
a "-1" will return the number as a text format and NOT a number so leave out the "" if you want a number

 

[Eireangel]

Excellent - thank you so much etaf. This works perfectly!

 

[etaf]

you are welcome