Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulae check
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulae check
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 wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulae check | Excel Worksheet Functions | |||
Check Box Formulae | Excel Worksheet Functions | |||
Formulae: Paste value formulae after doing an average operation | Excel Discussion (Misc queries) | |||
Increase size of a Forms Check Box (click on to enter check mark) | Excel Discussion (Misc queries) | |||
Searching TEXT in formulae, rather than results of formulae | Excel Worksheet Functions |