Rounding

S

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?
 
S

Sandy Mann

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

--
HTH

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
S

Sandy Mann

You're welcome. Thanks for the feedback

--
Reagrds,

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk
 
Top