| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
if formula in cell
Hi Team
What I want to do is, if Cell.... A1 contains formula then do something if it contain a number do something else. I thought it would be =if(ISREF(A1),100,200) or the ISNUM function, the IS function don't detect thanks Phill |
|
#2
|
|||
|
|||
|
if your formula results in a number =isnumber will say true......if it is
text ,false,if a date true.... -- paul remove nospam for email addy! "Hamster & Pene" wrote: Hi Team What I want to do is, if Cell.... A1 contains formula then do something if it contain a number do something else. I thought it would be =if(ISREF(A1),100,200) or the ISNUM function, the IS function don't detect thanks Phill |
|
#3
|
|||
|
|||
|
perhaps the = cell() function can detect the type of value you need?
-- paul remove nospam for email addy! "paul" wrote: if your formula results in a number =isnumber will say true......if it is text ,false,if a date true.... -- paul remove nospam for email addy! "Hamster & Pene" wrote: Hi Team What I want to do is, if Cell.... A1 contains formula then do something if it contain a number do something else. I thought it would be =if(ISREF(A1),100,200) or the ISNUM function, the IS function don't detect thanks Phill |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using contents of a cell in a formula | Excel Discussion (Misc queries) | |||
| Formula that referance a Cell | Excel Discussion (Misc queries) | |||
| Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
| Cell shows formula and not the result of the formula. | Excel Worksheet Functions | |||
| looking for a formula | Excel Worksheet Functions | |||
Linear Mode
