R
Rory
* a cell value by 53 % then round up the answer to have .95 on the end.
Thanks
Rory
Thanks
Rory
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Biff
Hi!
See if this is what you had in mind:
=INT(A1*0.53)+0.95
Biff
See if this is what you had in mind:
=INT(A1*0.53)+0.95
Biff
S
Sandy Mann
Rory,
Try:
=ROUND(A1*53%,0)-0.05
--
HTH
Sandy
In Perth, the ancient capital of Scotland
[email protected]
[email protected] with @tiscali.co.uk
Try:
=ROUND(A1*53%,0)-0.05
--
HTH
Sandy
In Perth, the ancient capital of Scotland
[email protected]
[email protected] with @tiscali.co.uk
B
Biff
=ROUND(A1*53%,0)-0.05
That "rounds down" in some cases:
38 * 0.53 = 20.14
ROUND(20.14,0)-0.05 = 19.95
Biff
That "rounds down" in some cases:
38 * 0.53 = 20.14
ROUND(20.14,0)-0.05 = 19.95
Biff
S
Sandy Mann
Yes it does - I missed the "round up" part in the OP
--
Thanks for the catch Biff.
Sandy
In Perth, the ancient capital of Scotland
[email protected]
[email protected] with @tiscali.co.uk
--
Thanks for the catch Biff.
Sandy
In Perth, the ancient capital of Scotland
[email protected]
[email protected] with @tiscali.co.uk
D
David Biddulph
See if this is what you had in mind:
=INT(A1*0.53)+0.95
If you really do want to round up, it might need
=INT((A1*0.53)+0.05)+0.95
so that if you have 53.99 after the multiplication it doesn't round down to
53.95 but rounds up to 54.95.
B
Biff
Yeah, that's another good point.
Now we just need some feedback from the OP to see what they really wanted!
Biff
Now we just need some feedback from the OP to see what they really wanted!
Biff