Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The case is like this. I'm doing an analysis that the result will come out as
2 numbers. One with any number with decimal (e.g. 123.456799) and the other one will come out as integra number (e.g. 1 2 3 4 5 and so on without decimal). The one with no decimal is the correct answer. When recognising the no. with no decimal, I want Excel to automatically insert another no. in other cell. Please help. Thanks a lot friends. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
SUMPRODUCT formula to differentiate between Negative and Positive | Excel Discussion (Misc queries) | |||
Formula to differentiate between product lines | Excel Discussion (Misc queries) | |||
VB Function Needed - Differentiate between a number and a characte | Excel Programming | |||
Converting 2-place decimal value to floating point decimal number with leading zero | Excel Discussion (Misc queries) | |||
Differentiate between Number and Date? | Excel Discussion (Misc queries) |