Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

excel formulae

ResolvedVersion 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

Excel tip:

Create a unique items table from a duplicating table

1. Ensure that your list has column headings
2. Select the entire list
3. From the menu bar, select DATA, FILTER, ADVANCED FILTER
4. Select "Filter the list, in place", and tick the "Unique Records Only" box
5. Click OK, filtered list appears.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.