J
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
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