Microsoft Office Forums - View Single Post - Do not calculate when multiple separated cells are all blank

Thread: Do not calculate when multiple separated cells are all blank

View Single Post

Old

11-13-2018, 03:47 AM

Marcia

Marcia is offline

Marcia uses Windows 7 32bit

Windows 7 32bit Marcia uses Office 2007

Marcia uses Office 2007

Office 2007

Expert

Join Date: May 2018

Location: Philippines

Posts: 551

Marcia has a spectacular aura about

Marcia has a spectacular aura about

Marcia has a spectacular aura about

Default

Hi, my operating system does not support the IFS function although I am using Excel 2016 version so try this formula and replace the IF with your IFS where appropriate

=IF(AND(A1="",B5="",C10=""),"",IF(A1+B5+C10=0,"YES ","NO"))

Reply With Quote