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.9 9)
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
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Excellent, thanks !!!