Solved Excel formula parse error

May 23, 2016 at 12:05:37
Specs: Windows 7
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.


See More: Excel formula parse error

Report •


#1
May 23, 2016 at 12:20:45
✔ Best Answer
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))

MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Report •

#2
May 23, 2016 at 12:28:03
Many thanks for that. I had written the formula in Notepad. Didn't notice that!! :-)

Report •

#3
May 25, 2016 at 09:56:16
Just curious...

What version of Excel are you using? I get an error because of the quotes, but it's the generic "The formula you typed contains an error" message.

I don't recall ever seeing a "formula parse error" in any version I've ever used.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Related Solutions

#4
May 25, 2016 at 12:04:41
I believe that the "formula parse error" is a Google incantation and is not native to Excel.

MIKE

http://www.skeptic.com/


Report •

#5
May 25, 2016 at 12:19:30
Thanks!

(Short Message
The message that you entered is too short to be helpful. Please add more information before posting. It must be at least 4 words long.)

Apparently we are not allowed to just says "Thanks". ;-)

message edited by DerbyDad03


Report •

#6
May 25, 2016 at 12:34:21
Hi DerbyDad03, mmcconaghy

In fact I was using the online version (Google Sheets).

Cheers


Report •

#7
May 25, 2016 at 12:42:23
Thanks for the verification but...

I don't think I would use the words "the online version (Google Sheets)" which implies that Google Sheets is an online version of Excel.

Google Sheets is indeed an on-line spreadsheet application, but it is certainly not Excel.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •


Ask Question