acknowledge divisability of $20 indicate mathematical results
- From: Kessie <Kessie@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Sun, 10 Apr 2005 13:39:02 -0700
Need help designing a formula to discern the nearest increment of $20.00 then
show the results - one to indicate the result of the original subtraction
(e.g., $539.00 - $520.00 with $520.00 being the result) and the other column
with the remaining amount (e.g., $19.00).
This example would include three columns: 1) The original amount, 2) the
total result of $20.00 increments, and 3) what remains from the original
amount.
Is this possible? Thanx for any assistance.
.
- Follow-Ups:
- Re: acknowledge divisability of $20 indicate mathematical results
- From: Tushar Mehta
- RE: acknowledge divisability of $20 indicate mathematical results
- From: Ron Coderre
- Re: acknowledge divisability of $20 indicate mathematical results
- Prev by Date: Re: On Error Resume Next
- Next by Date: Re: Evaluate using a variable - Help please - Thanks for your help
- Previous by thread: Application-defined or Object-defined error
- Next by thread: RE: acknowledge divisability of $20 indicate mathematical results
- Index(es):