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