Formulae check

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
 
P

Peo Sjoblom

The formula is incorrect, this part

IF(AND(R8:R10)=""

will only look at the first value, not R9 and R10


and what do you expect this part to do?


IF(ISNUMBER(R10);R10;R8


it doesn't make any sense since it cannot return the range

If you mean that is any of the cells in R8:R10 is blank then do ""

=IF(SUMPRODUCT(--(R8:R10=""))>0,""


but the second part is harder to decipher


--


Regards,


Peo Sjoblom










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
 
Top