troubleshooting Question

Rookie Excel formula question

Avatar of Natchiket
NatchiketFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft ExcelMicrosoft Office
5 Comments1 Solution15 ViewsLast Modified:
Hi I would like to use conditional formatting so that that if the result of a caculation is positive zero or negative then background colour the cell appropriately.  The issue is, if the cells being used are blank then I want the result to be blank (rather than zero), so that no formatting applies.

This is what I have at the moment:
=IF(AND(ISBLANK(E6),ISBLANK(G6)),"",E6-G6)
To try and get a blank target cell when E6 and G6 are blank, this seems rather ineffiecent, is there a better way of doing it?

The same with summation
=SUMIF(E6:E17,"<>""") still results in a '0' in the target cell how can I make the result blank if the range E6:E17 is blank?


ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros