|
|
|
|
#1
11-13-2018, 03:47 AM
|
||||
|
||||
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")) 
|
|
#2
11-13-2018, 09:41 AM
|
|||
|
|||
Thank you!
Thank you Marcia!!! Your suggestion worked perfectly! I didn't even use IFS, I just inserted your formula, which was also more concise than what I had written. I really struggled with this so I am VERY appreciative of your feedback.
Microsoft Excel Forum - you rock...!!!  Jonathan
|
|
|
|
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 |
Windows 7 32bit 
Office 2007
Hybrid Mode