Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Test for Decimal
In a section of code I am using the MOD function to test for cases where a
given number is a multiple of 51. If Range("A1") MOD 51 = 0 then ....more code In cell A1 I have 203.52. The function is returning true because the 203.52 is rounded up to 204 as part of the MOD test. I don't want to apply code to A1l and need to test for the decimal before I use the MOD function, I think. If Range("A1") < "decimal" then If Range("A1") MOD 51 = 0 then ...more code Is this the logic I need and how do I test for the decimal? Thanks. -- Ken Hudson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Logical test IF a decimal was typed in a cell | Excel Worksheet Functions | |||
Subtracting two 2-decimal place numbers gives result 13-decimal places? | Excel Worksheet Functions | |||
Batch converting CSV files from comma-decimal to period-decimal | Excel Discussion (Misc queries) | |||
Converting 2-place decimal value to floating point decimal number with leading zero | Excel Discussion (Misc queries) | |||
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) |