excel formulae

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel formulae

Excel formulae

resolvedResolved · 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


 

Excel tip:

Selecting blank cells within a range of data

Select 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.

View all Excel hints and tips


Server loaded in 0.08 secs.