Formulae check

[jamalhakem]

Hi
Any help?
I have this data
30

50
50 #VALUE!

=IF(AND(R8:R10)="";"";IF(ISNUMBER(R10);R10;R8))
This formula works when there numbers but it does not work when the
cell resulting from other formulae is “”, or blank cells
I want to carry a tests when the cells are “”, should return “”, and
when there are numbers, should meet the criteria.
Other question:
ISBLANK only checks if the cells are really empty “”?
Thanks in advance
Jam

 

[Thomas [PBD]]

Jamalhakem,

Try the following function:
=IF(ISERROR(AND(R8:R10)=""),"",IF(ISNUMBER(R10),R10,R8))