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.

 

[Jonmo1]

Try this assuming F2 and G2 are always positive numbers or blank.

=IF(OR(F2>0,G2>0),1+(F2=G2),0)

 

[omairhe]

Try this assuming F2 and G2 are always positive numbers or blank.

=IF(OR(F2>0,G2>0),1+(F2=G2),0)

Thanks, works neatly..

 

[Jonmo1]

Glad to help, thanks for the feedback.

 

[omairhe]

Dear Jonmo1,

It seems that I need a new change in the recent formula ..

Considering H2 to be my resulting cell the following should be the output for respective scenario... Here I added a new constant = '3'.. IF the cells F2 or G2 or both are blank thus output 3, rest of formula being the same.

F2....G2....H2

10....10.....2

5......5......2

0......0......0

1......0......1

0......1......1

....... ......3

0...... ......3

......0......3

60...50.....1



will appreciate..

 

[Jonmo1]

Ok, you've really got to stop the 'Bait and switch'

How do you do A : by doing x
How do you do B : by doing y
Now how do you do both A and B at the same time :by doing z
Great, but what I really want is A B and C...

Ask what you really want in the first place.


Anyway, that said.
Try

=IF(OR(F2="",G2=""),3,IF(OR(F2>0,G2>0),1+(F2=G2),0))

 

[omairhe]

thank u.. yes true