| 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
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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) | |||
| Check if Conditional Format is True or False / Check cell Color | Excel Worksheet Functions | |||
| Searching TEXT in formulae, rather than results of formulae | Excel Worksheet Functions | |||
Linear Mode
