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?
Parse error with =IF function
google spreadsheets