Basic ISBLANK problem

[Shales]

Hi,

Struggling to get a formula to work, could do with some help please?

This is the formula I am using =IF(ISBLANK(I5:T5),H5,0)

Even though my (I5:T5) is blank it is not returning the number in H5. I just get a 0.00

Any suggestions?

Thanks
Gavin

 

[MrKowz]

ISBLANK can't test multiple cells. Also, if I5:T5 have any formulas in them, ISBLANK wouldn't work anyway.

Try:

=IF(COUNTIF(I5:T5,"")>0,H5,0)

 

[T. Valko]

Hi,

Struggling to get a formula to work, could do with some help please?

This is the formula I am using =IF(ISBLANK(I5:T5),H5,0)

Even though my (I5:T5) is blank it is not returning the number in H5. I just get a 0.00

Any suggestions?

Thanks
Gavin

You're referring to an array of cells with ISBLANK(I5:T5).

So, do you want the result to be returned if EVERY cell in the range is blank or if ANY cell is blank?

 

[Shales]

Perfect. The Counta solution worked fine.

Thanks