asked on

I had this question after viewing Excel IF statement.

I have 3 possible values now,

"5+ times"

"2-4 times"

"0-1 times"

How do I alter this statement: =IF(E25="YES",1,0) to allow for this logic?

"5+ times" = 1

"2-4 times" = 2

"0-1 times" = 3

Thank you!

JohnD

I have 3 possible values now,

"5+ times"

"2-4 times"

"0-1 times"

How do I alter this statement: =IF(E25="YES",1,0) to allow for this logic?

"5+ times" = 1

"2-4 times" = 2

"0-1 times" = 3

Thank you!

JohnD

Microsoft Excel