ExcelBanter - if formula in cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - if formula in cell (https://www.excelbanter.com/excel-worksheet-functions/30121-if-formula-cell.html)

Hamster & Pene

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

paul

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

paul

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

All times are GMT +1. The time now is 03:41 PM.