Required Numeric
 

Is there any way with a formula to make sure a cell is numeric and to post an
error message if it is NOT numeric???

=IF(ISERROR(1*F12),"F12 is not numeric","")


"RTP" wrote in message
...
Is there any way with a formula to make sure a cell is numeric and to post
an
error message if it is NOT numeric???

Click on your cell and then go to the 'Data' tab at the top menu and click on
Validation. You can then select 'decimal' for what's allowed and allow
anything between -99999999999 and 99999999999. If someone enters letters
instead of numbers it will provide an error message, which you can specify
under the 'Error Alert' tab on that validation area.

TM

"RTP" wrote:

Is there any way with a formula to make sure a cell is numeric and to post an
error message if it is NOT numeric???

Try IsNumber(). It returns a true or false. You can put this inside an if
to produce other messages, for example: =if(isnumber(A2),"","OOPS").

Alternatively you can use a conditional format within the cell you're
testing to change the format (like background color) if it's non numeric.

To do this, go to conditional format, select "formula is", and type:
= NOT(ISNUMBER(A2))
And then select your format

Art

Hi
=IF(ISNUMBER(A1),"OK","Not ok")

--
Regards
Frank Kabel
Frankfurt, Germany

"RTP" schrieb im Newsbeitrag
...
Is there any way with a formula to make sure a cell is numeric and to
post an
error message if it is NOT numeric???

Use Format | Conditional Formatting
Set Formula to =NOT(ISNUMBER(A1)) ---- change reference to suit need
And make font and/or pattern to colour (red?)

best wishes

--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


"RTP" wrote in message
...
Is there any way with a formula to make sure a cell is numeric and to post
an
error message if it is NOT numeric???