Home/ Questions/Q 5496
Next
In Process
Computing Staff
  • 2
Asked: 2021-11-15T13:03:03+00:00 In:

Excel Formula Parse Error

  • 2

Hello,

Can someone please tell me why this is giving me a ‘formula parse error’?

=IF(ISBLANK(I6),ʺblankʺ,((((I6-I5)*2.3))+(((J6-J5)*0.26))))

Thanks.

Share

    1 Answer

    1. Did you perhaps write the formula in Word?
      It’s your smart quotes that Excel does not like.

      and why all the parenthesis, this works just as well

      =IF(ISBLANK(I6),”blank”,((I6-I5)*2.3)+((J6-J5)*0.26))

      • 0