LinkBack URL
About LinkBacksIf the total of a cell is any decimal part more than the whole number (
Example 1.01 raise it to the next whole number 2) and then multiply by a
known number.
Answer 1.01 now becomes 2 X 50
If the total of a cell is any decimal part more than the whole number (
Example 1.01 raise it to the next whole number 2) and then multiply by a
known number.
Answer 1.01 now becomes 2 X 50
Assume the number is in Cell A1
=roundup(A1, 0)*50
--
HTH...
Jim Thomlinson
"InspectorPaul" wrote:
> If the total of a cell is any decimal part more than the whole number (
> Example 1.01 raise it to the next whole number 2) and then multiply by a
> known number.
>
> Answer 1.01 now becomes 2 X 50
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks