0

I put this in:

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

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?

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

1 Answer 1

3

Maybe this is what you need ?

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

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 that you have read and understand our privacy policy and code of conduct.

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