Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
working with decimal remainder
hi all,
if i have a number in a cell (say 2.456) and i want to work with ONLY the 0.456 - is there a function that will let me do that i can write a function in vba to take care of everything - i would prefery to stay with worksheet functions as much as possible. basically i am working with dollars and cents - and i want to create a conditional function that will adjust the prices according to $X.00 - $(X-1).99 $X.01 - $X.24 - $X.25 $X.25 - $X.49 - $X.50 $X.50 - $X.99 - $X.99 thanks for your help! J |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I set up the remainder to display in Excel? | Excel Discussion (Misc queries) | |||
Rolling over a Remainder | Excel Worksheet Functions | |||
Remainder | Excel Discussion (Misc queries) | |||
remainder in a division | Excel Worksheet Functions | |||
Remainder Zero Function? | Excel Worksheet Functions |