Excel Formula Help
 

I need a formula that will truncate the value and provide the dollar amount
as follows:

Entry Calculated Number
$10.00 = $0.00
$22.50 = $2.50
$50.00 = $0.00
$75.00 = $5.00

I basically need to see the value of the last three digits of the amount
posted in the column. The column contains over 5000 entires, which is why I
need a formula.

Thanks
--
Doug

Excel Formula Help
 

Try

=A1-FLOOR(A1,10)

formatted as currency


--

Regards,

Peo Sjoblom




"Doug" wrote in message
...
I need a formula that will truncate the value and provide the dollar amount
as follows:

Entry Calculated Number
$10.00 = $0.00
$22.50 = $2.50
$50.00 = $0.00
$75.00 = $5.00

I basically need to see the value of the last three digits of the amount
posted in the column. The column contains over 5000 entires, which is why
I
need a formula.

Thanks
--
Doug

Excel Formula Help
 

Maybe this:

=MOD(A1,10)

Copy down as needed

--
Biff
Microsoft Excel MVP


"Doug" wrote in message
...
I need a formula that will truncate the value and provide the dollar amount
as follows:

Entry Calculated Number
$10.00 = $0.00
$22.50 = $2.50
$50.00 = $0.00
$75.00 = $5.00

I basically need to see the value of the last three digits of the amount
posted in the column. The column contains over 5000 entires, which is why
I
need a formula.

Thanks
--
Doug