Avatar of John Darby
John Darby
Flag for United States of America

asked on 

Excel IF AND, OR phrasing

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
Microsoft Excel

Avatar of undefined
Last Comment
John Darby

8/22/2022 - Mon