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

how not calculate if

Forum home » Delegate support and help forum » Microsoft Excel Training and help » How to Not Calculate If Cell is Blank in Excel (Ignore Formula)

How to Not Calculate If Cell is Blank in Excel (Ignore Formula)

ResolvedVersion 365

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

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

Excel tip:

Quickly Adding New Worksheets

Want to place a new Excel worksheet before current worksheet. Use keystroke SHIFT+F11

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.09 secs.