Do not calculate when multiple separated cells are all blank

		Microsoft Office Forums > Microsoft Excel > Excel
Do not calculate when multiple separated cells are all blank

FAQ

Thread Tools

Display Modes

11-13-2018, 10:20 AM

Pecoflyer

Windows 7 64bit Do not calculate when multiple separated cells are all blank

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,948

Pecoflyer has a reputation beyond repute

I think your IFS would be =IFS(AND(A1="",B5="",C10=""),"",A1+B5+C10=0,"YES", A1+B5+C10<>0,"NO")
(which is much longer)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
multiple conditions, and blank cells with the countifs function	jaden0605	Excel	1	03-30-2014 01:50 AM
Join cells together separated by ; when some are blank	leemoreau	Excel	3	11-03-2013 11:22 AM
Calculate differences between text cells?	poobear	Excel	2	05-19-2012 06:43 AM
How to segregate a single record into separated cells	KIM SOLIS	Excel	3	09-09-2011 02:54 AM
How to get cells to calculate time?	jrasche2003@yahoo.com	Excel	2	02-09-2007 07:10 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:13 PM.