Mon 27 Jan 2025, 10:25Delegate Patrycja said...
Patrycja has attended:
Excel Intermediate course
Power BI Reporting course
Power BI DAX course
How to Not Calculate If Cell is Blank in Excel (Ignore Formula)
My formula is - =IF(O3<=E3,"Y","N")
I'm looking to find a way to add to it, if a O cell is blank then return blank
Thank you
Mon 27 Jan 2025, 10:45Trainer Jens said...
RE: How to Not Calculate If Cell is Blank in Excel (Ignore Formu
Hi Patrycja,
Thank you for the forum question.
Try:
=IFS(O3="","",O3<=E3,"Y",true,"N")
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
