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. Feb 9 '15 at 13:15

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, privacy policy and cookie policy

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