troubleshooting Question

Getting #VALUE Result in a Simple Excel Formula

Avatar of Bill Golden
Bill GoldenFlag for United States of America asked on
Microsoft Excel
8 Comments1 Solution48 ViewsLast Modified:
I know what is wrong. I just do not know how to fix it.
B2, contains a number
C2, contains a number
D2, subtracts, B2-C2 and puts the result in D2, IF B2>0 and C2>0, otherwise D2 contains " "
F2, contains a number
G2, contains a number
H2, subtracts, F2-G2 and puts the result in H2, IF F2>0 and G2>0, otherwise H2 contains " "
At this point, everything works fine!
J2 subtracts D2-H2, IF D2>0 and H2>0, otherwise should put " " in H2
THAT WORKS, AS LONG AS D2 AND H2 CONTAIN A NUMBER, BUT
If B2 or C2 or F2 or G2 does not contain a number, J2 Returns #VALUE
Obviously I need to store something besides " " in F2 and H2 when B2 or C2 or F2 or G2 is blank.
Sample file attached.
EE-IFAND-SAMPLE.xlsx
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 8 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 8 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