Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to delete blank rows | Excel Discussion (Misc queries) | |||
blank cells | Excel Discussion (Misc queries) | |||
Blank Cells in Pivot Tables | Excel Discussion (Misc queries) | |||
VLOOKUP, OFFSET, MATCH PROBLEM, HELP? | Excel Worksheet Functions | |||
COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C. | Excel Discussion (Misc queries) |