IF statement

[Phil]

Is it possible to have formula in the true or false part of the If
statement? For instance...

=IF(I2>0,"=SUMPRODUCT(--(B7:B8=g11:h11))",0)

When the statement is true i am getting ,"=SUMPRODUCT(--(B7:B8=g11:h11))
when what i want is the value of the formula not the formula itself.

Thanks

 

[Frank Kabel]

Hi
use
=IF(I2>0,SUMPRODUCT(--(B7:B8=g11:h11)),0)

 

[Phil]

DOH, of course!! Thanks

Hi
use
=IF(I2>0,SUMPRODUCT(--(B7:B8=g11:h11)),0)