using text as a "true" condition in an if function.
 

I need to write an if function that says when text is enterd in a cell it
needs to return "please enter a value!!!" I cant remember how to define text
in the if function. example. if(A1="text","Please enter a value!!!") I need
it to say that if anything other than a # is entered in the cell beside it.
And ive tried the one i put here and it only works if i put the word text in
the cell.

Thanks for any help

using text as a "true" condition in an if function.
 

You are probably thinking of the ISTEXT function?
--
David Biddulph

"diggyroo" wrote in message
...
I need to write an if function that says when text is enterd in a cell it
needs to return "please enter a value!!!" I cant remember how to define
text
in the if function. example. if(A1="text","Please enter a value!!!") I
need
it to say that if anything other than a # is entered in the cell beside
it.
And ive tried the one i put here and it only works if i put the word text
in
the cell.

Thanks for any help

using text as a "true" condition in an if function.
 

One way:

=IF(ISTEXT(A1),"Enter a number!","")

However, if cell A1 is formatted as TEXT and a number is entered it will be
evaluated as TEXT and return the message.

--
Biff
Microsoft Excel MVP


"diggyroo" wrote in message
...
I need to write an if function that says when text is enterd in a cell it
needs to return "please enter a value!!!" I cant remember how to define
text
in the if function. example. if(A1="text","Please enter a value!!!") I
need
it to say that if anything other than a # is entered in the cell beside
it.
And ive tried the one i put here and it only works if i put the word text
in
the cell.

Thanks for any help

using text as a "true" condition in an if function.
 

hi
something like this might work.....
=IF(ISTEXT(A3),"Enter a value","")

Regards
FSt1

"diggyroo" wrote:

I need to write an if function that says when text is enterd in a cell it
needs to return "please enter a value!!!" I cant remember how to define text
in the if function. example. if(A1="text","Please enter a value!!!") I need
it to say that if anything other than a # is entered in the cell beside it.
And ive tried the one i put here and it only works if i put the word text in
the cell.

Thanks for any help

using text as a "true" condition in an if function.
 

Thank you all very much. The funny thing is i new it as soon as i read the
replys. Thanks for the reminder.

"T. Valko" wrote:

One way:

=IF(ISTEXT(A1),"Enter a number!","")

However, if cell A1 is formatted as TEXT and a number is entered it will be
evaluated as TEXT and return the message.

--
Biff
Microsoft Excel MVP


"diggyroo" wrote in message
...
I need to write an if function that says when text is enterd in a cell it
needs to return "please enter a value!!!" I cant remember how to define
text
in the if function. example. if(A1="text","Please enter a value!!!") I
need
it to say that if anything other than a # is entered in the cell beside
it.
And ive tried the one i put here and it only works if i put the word text
in
the cell.

Thanks for any help

using text as a "true" condition in an if function.
 

You're welcome!

--
Biff
Microsoft Excel MVP


"diggyroo" wrote in message
...
Thank you all very much. The funny thing is i new it as soon as i read the
replys. Thanks for the reminder.

"T. Valko" wrote:

One way:

=IF(ISTEXT(A1),"Enter a number!","")

However, if cell A1 is formatted as TEXT and a number is entered it will
be
evaluated as TEXT and return the message.

--
Biff
Microsoft Excel MVP


"diggyroo" wrote in message
...
I need to write an if function that says when text is enterd in a cell
it
needs to return "please enter a value!!!" I cant remember how to define
text
in the if function. example. if(A1="text","Please enter a value!!!") I
need
it to say that if anything other than a # is entered in the cell beside
it.
And ive tried the one i put here and it only works if i put the word
text
in
the cell.

Thanks for any help