Rounding dollar amount to nearest $1

[Maddoktor]

Hi all,

I was wondering what the formula is if I wanted to round a dollar amount
to the nearest dollar.

i.e. $150.63 should equal $151.00
i.e. $150.23 should equal $150.00

Thanx in advance.

[Ardus Petus]

Say your $ amount is in A1, enter in B1:
=ROUND(A1,0)

HTH
--
AP

"Maddoktor" <[email protected]> a écrit dans le message de news:
%[email protected]...
> Hi all,
>
> I was wondering what the formula is if I wanted to round a dollar amount
> to the nearest dollar.
>
> i.e. $150.63 should equal $151.00
> i.e. $150.23 should equal $150.00
>
> Thanx in advance.

[Maddoktor]

Thanx Ardus,

Exactly what I wanted.



Ardus Petus wrote:
> Say your $ amount is in A1, enter in B1:
> =ROUND(A1,0)
>
> HTH
> --
> AP
>
> "Maddoktor" <[email protected]> a écrit dans le message de news:
> %[email protected]...
>> Hi all,
>>
>> I was wondering what the formula is if I wanted to round a dollar amount
>> to the nearest dollar.
>>
>> i.e. $150.63 should equal $151.00
>> i.e. $150.23 should equal $150.00
>>
>> Thanx in advance.
>
>

[Don Guillett]

Had you considered looking in the help index for ROUND?

--
Don Guillett
SalesAid Software
[email protected]
"Maddoktor" <[email protected]> wrote in message
news:%[email protected]...
> Hi all,
>
> I was wondering what the formula is if I wanted to round a dollar amount
> to the nearest dollar.
>
> i.e. $150.63 should equal $151.00
> i.e. $150.23 should equal $150.00
>
> Thanx in advance.