Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
Forum home » Delegate support and help forum » Microsoft Excel Training and help » IF formula
Resolved · Medium Priority · Version 2016
Kay has attended:
Excel Advanced course
Excel Advanced - Formulas & Functions course
Hi,
Please can you help me understand how to do the following?
I have an equation (as below) to return “Yes” if there is an “X” in columns F-N
=IF(OR(F218="X",G218="X",H218="X",I218="X",J218="X",K218="X",L218="X",M218="X",N218="X"), "Yes","")
My equation works fine however the issue is that my range has not extended to columns F-BG making this an extensively long and lengthy equation.
I am unable to share the actual file however please can I ask what is the best or easiest formula to do this please? Many thanks
Hi Kay,
Thank you for the forum question.
Try:
=If(countif(f218:bg218,"X")>1,"yes","")
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Fri 20 Sep 2019: Automatically marked as resolved.
|
Excel tip:Recently used file listUnder the File menu, you may find a list of files at the bottom of the menu. These files represent the most recently used Excel spreadsheets. This file list provides a quick way for you to access your files. |
We'll call during UK business hours
Server loaded in 0.05 secs.