Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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??? |
#2
|
|||
|
|||
=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??? |
#3
|
|||
|
|||
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??? |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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??? |
#6
|
|||
|
|||
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??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|