Parse error with =IF function

Ask Question

Asked 8 years, 10 months ago

Modified 8 years, 10 months ago

Viewed 156 times

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?

22.8k16 gold badges101 silver badges191 bronze badges

asked Feb 9, 2015 at 2:57

Rod

91 bronze badge

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

Add a comment |

1 Answer 1

Sorted by:

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))

answered Feb 9, 2015 at 7:04

JPV

2,52911 silver badges15 bronze badges

Add a comment |

Name

Required, but never shown

Post as a guest

Name

Required, but never shown

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.