|
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 |
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 |
| All times are GMT +1. The time now is 04:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com