Jamalhakem,

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

--
--Thomas [PBD]
Working hard to make working easy.
Answered your question? Click ''Yes'' below.


" wrote:

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