If value is missing in any column, then cannot perform operation

[chubbychub]

Hi, i need some help in figuring out this formula:
in cell H3 i have:

=SI(D3="","",D3-(E3+G3+C3))

but i want to see if there is missing value in C3 and/or D3 then the formula will output "Missing Value" instead of perfroming the operation. I have attached the excell sheet. Please help , thanks in advanced.

[:) Sixthsense :)]

Try this in cell H2

=IF(D2="","",IF(OR(C2="",D2=""),"Missing Value",D2-(E2+G2+C2)))
Drag it down

Hope that helps!

[chubbychub]

that worked for C2, but when a value is missing in d2, its blank, how can you make it to print "Missing Value in D2" when nothing is entered in d2?
Thanks in advance.

[:) Sixthsense :)]

Try this in cell H2

Please Login or Register  to view this content.

Hope that helps!