If Formula

[omairhe]

Peace,

what formula that checks cell F2 and cell G2 for 0/blank values.

If both the above cells are 0/blank then give output 0 otherwise give output 1.

Thanks.

 

[nuked]

=(and(isblank(f2),isblank(g2)))

 

[Jonmo1]

What type of value would be in the cells if they are not 0/blank ? Text or Number?

 

[nuked]

This might be better:

=AND((OR(ISBLANK(F2),F2=0)),OR(ISBLANK(G2),G2=0))

 

[omairhe]

ADVERTISEMENT

Numeric.

What type of value would be in the cells if they are not 0/blank ? Text or Number?

 

[Jonmo1]

try
=--(SUM(F2:G2)<>0)

 

[omairhe]

ADVERTISEMENT

YES thanks..

try
=--(SUM(F2:G2)<>0)

 

[Jonmo1]

YES thanks..

Glad to help

Important to note that if the cells have negative numbers, and the sum of those numbers = 0, then you get a false when it should be true.
Example
F2=2
G2=-2
sum(F2:G2)=0, formula results in 0

 

[omairhe]

negative may not occur in such an instance. Is number and all positive. thanks again..

 

[omairhe]

Dear jommo1,

I needed to say the formula y've posted is running fine however it'd be great if it could output values in " 0 , 1 and 2 "

example "0"

F2 = 0 or blank
G2 = 0 or blank

hence H2 = 0

example "1"

F2 = 50 or any other value except for 0
G2 = 0 or any other value except for 50

hence H2 = 1

example "2"

F2 = 50 or same value as G2 except for 0
G2 = 50 or same value as F2 except for 0

hence H2 = 2

please let me know if further clarification is required.