Jane has attended:
Excel Advanced course
Excel formulae
Hi , I have created a spreadsheet that requires the user to select the correct answer from a drop down list. Following their selection I wanted to advise the user in a seperate column if their answer was correct or not. I used the following formulae but it did not work:
=IF(OR(B2=O8,O10,O17,O18,O19,O24,O25),"Y","N")
Please could you advise
RE: Excel formulae
Hi Jayne,
Can you give me a bit more information on what's not working with your formula? Maybe you could attach the file so I can see the whole problem?
thanks
Claire
RE: Excel formulae
Could you provide an email address to forward the document
RE: Excel formulae
Hi Jayne,
Can you send it to : forum@stl-training.co.uk
Can you put Claire in the subject so we can match it up?
thanks
Claire
RE: Excel formulae
Undeliverable:
VE1EUR02FT059.mail.protection.outlook.com rejected your message to the following email addresses:
forum@stl-training.co.uk (forum@stl-training.co.uk)
Your message was rejected by the recipient's domain because the recipient's email address isn't listed in the domain's directory. It might be misspelled or it might not exist. Try to fix the problem by doing one or more of the following:
Send the message again - delete and retype the address before resending. If your email program automatically suggests an address to use, don't select it - type the complete email address.
Clear the recipient Auto-Complete List in your email program by following the steps in this article. Then resend the message.
For Email Administrators
Directory based edge blocking is enabled for the recipient's organization and the recipient wasn't found in their directory. If the sender is using the correct address but continues to experience the problem, contact the recipient's email admin and tell them about the problem. To fix this they should resynchronize their on-premises and cloud directories.
RE: Excel formulae
Hi Jayne,
So sorry about the confusion on this.
Could you try again with this one?
info@stl-training.co.uk
thanks
Claire
RE: Excel formulae
Hi Jayne,
Did you get a chance to send in the file? Or maybe you've managed to solve the problem?
thanks
Claire