is blank and

[Guest]

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

 

[Guest]

Not = an operator

you can use in conjunction with isempty

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


not sure about the rounding function.

 

[David McRitchie]

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