jonatec

asked on

# Excel formula unrecognised symbol

Hi

I have to reverse engineer an Excel spreadsheet and have come across a "pipe" (vertical bar) symbol in a formula, can anyone please explain this ??

= AND($L$877>5.99|$M$877>5.99)

I have to reverse engineer an Excel spreadsheet and have come across a "pipe" (vertical bar) symbol in a formula, can anyone please explain this ??

= AND($L$877>5.99|$M$877>5.9

That is probably due to regional settings. Depending on yours, change it to a ',' or to a ';'. Basically, whatever is the delimitator in your excel functions (like what separates IF parts (condition, true, false)

It could well be an "or"

It is definitely a comma

Check your or the users settings in the control panel for regional options ... see under additional settings what is selected for the list seperator.

Chris

Chris

ASKER

So if it's a delimiter, should the formula translate to this???

= AND ( $L$877 > 5.99 OR $M$877 > 5.99 )

or;

= AND ( $L$877 > 5.99 AND $M$877 > 5.99 )

thanks

= AND ( $L$877 > 5.99 OR $M$877 > 5.99 )

or;

= AND ( $L$877 > 5.99 AND $M$877 > 5.99 )

thanks

No:

= AND ( $L$877 > 5.99,$M$877 > 5.99 )

for typical English regional settings.

= AND ( $L$877 > 5.99,$M$877 > 5.99 )

for typical English regional settings.

ASKER

In my regional settings the "|" (pipe) is a list seperator.

ASKER

rorya:

thanks, could you translate the formula for me into English ?

thanks, could you translate the formula for me into English ?

ASKER CERTIFIED SOLUTION

membership

Create a free account to see this answer

Signing up is free and takes 30 seconds.

**No credit card required.**ASKER

Excellent, thanks !!!