I put this in:


and it keeps coming up with a parse error and I have tried to switch ; with , and it still didn't work.

How do I make this work?

  • If you would share a spreadsheet demonstrating the problem, it would be much easier to see what's going in. Commented Feb 9, 2015 at 13:15

1 Answer 1


Maybe this is what you need ?


or, depending on your locale:

=IF(A4=2, 1, IF(A4=4, 7, A4))

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.