Rounding

[Sue]

Need to round the results in this field to the nearest whole dollar
My current formula in the cell is =(U2*105%)+500
Can I use the round function someway in this formula?

 

[Sandy Mann]

=ROUND(U2*105%+500,0)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[CLR]

=ROUND((U2*105%)+500,0)

Vaya con Dios,
Chuck, CABGx3

 

[Sue]

Thanks it worked perfectly

=ROUND(U2*105%+500,0)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Sandy Mann]

You're welcome. Thanks for the feedback

--
Reagrds,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk