Kay has attended:
Excel Advanced course
Excel Advanced - Formulas & Functions course
IF formula
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
RE: IF formula
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