is blank and
 

Is there an isnotblank function ?
Also is there a function I can write to check if a cell is rounded to the
nearest 1/8th or can I make validation make sure the cell is entered to an
1/8th
Thanks,
Yosef

Not = an operator

you can use in conjunction with isempty

....
if NOT (isempty(myCell)) then
....


not sure about the rounding function.





"ynissel" wrote:

Is there an isnotblank function ?
Also is there a function I can write to check if a cell is rounded to the
nearest 1/8th or can I make validation make sure the cell is entered to an
1/8th
Thanks,
Yosef

Hi Tom,
Why do need to check if something is rounded as opposed to
simply rounding and how does validation apply.

Take a look at
Fractions rounded to 1/4, 1/8, 1/16, 1/32, 1/64, 1/128
http://www.mvps.org/dmcritchie/excel/fractex1.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"TomHinkle" wrote in message ...
Not = an operator

you can use in conjunction with isempty

...
if NOT (isempty(myCell)) then
...


not sure about the rounding function.





"ynissel" wrote:

Is there an isnotblank function ?
Also is there a function I can write to check if a cell is rounded to the
nearest 1/8th or can I make validation make sure the cell is entered to an
1/8th
Thanks,
Yosef