98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Excel formulae
Excel formulae
Resolved · High Priority · Version 2016
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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Selecting blank cells within a range of dataSelect the range of data which includes the blank cells that you would like to select. Press the F5 key, this will take you to the GoTo dialogue box where you can click on Special and then select Blanks. |