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)
jonatecAsked:
Who is Participating?
 
Rory ArchibaldCommented:
In that case the formula is correct as it is. The pipe is just separating the arguments of the AND function.
The formula returns true if both L877 and M877 are greater than 5.99
0
 
CluskittCommented:
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)
0
 
mkobrinCommented:
It could well be an "or"
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Saqib Husain, SyedEngineerCommented:
It is definitely a comma
0
 
Chris BottomleySoftware Quality Lead EngineerCommented:
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
0
 
jonatecAuthor Commented:
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
0
 
Rory ArchibaldCommented:
No:
= AND ( $L$877 > 5.99,$M$877 > 5.99 )
for typical English regional settings.

0
 
jonatecAuthor Commented:
In my regional settings the "|" (pipe) is a list seperator.
0
 
jonatecAuthor Commented:
rorya:

thanks, could you translate the formula for me into English ?
0
 
jonatecAuthor Commented:
Excellent, thanks !!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.