0
=IF(B2=0,0,800*2(B2-1))

Why won't my function work in Google Sheets? Why can't I get an equation to work inside an IF function?

2
  • 1
    Welcome to Web Applications. The formula doesn't work in Google Sheets because it's not using the correct syntax: an operator is missing between 2 and (. Please checkout Add formulas & functions to learn the basics of Google Sheets formulas.
    – Rubén
    Sep 21 at 20:24
  • Thank you! I was missing the ^ symbol, next time i'll pay more attention to my equation! Sep 24 at 19:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.