Update Formula Help

[Brew]

Is there a way to update the following formulas, so that if AF698:AH698 are blank, so that the returned result is a blank in the cell or it can say false or no. Anything but a numerical return.

=ISEVEN(AF698)+ISEVEN(AG698)+ISEVEN(AH698)

Also, the same for this formula
=IF(AND(AF698=AG698,AF698=AH698),3,IF(AND(AF698<>AG698,AF698<>AH698,AG698<>AH698),1,2))

 

[PaddyD]

an if structure along the following lines might help:

=if(SUMPRODUCT(LEN(af698:ah698)+0)=0,"",your_formula)

 

[Brew]

Thanks PaddyD. That works just fine.

 

[Aladin Akyurek]

=IF(COUNTBLANK(Range),X,Y)

would suffice