How to write this formula?
 

* a cell value by 53 % then round up the answer to have .95 on the end.

Thanks
Rory

How to write this formula?
 

Hi!

See if this is what you had in mind:

=INT(A1*0.53)+0.95

Biff

"Rory" wrote in message
...
* a cell value by 53 % then round up the answer to have .95 on the end.

Thanks
Rory

How to write this formula?
 

Rory,

Try:

=ROUND(A1*53%,0)-0.05

--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"Rory" wrote in message
...
* a cell value by 53 % then round up the answer to have .95 on the end.

Thanks
Rory

How to write this formula?
 

=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

"Sandy Mann" wrote in message
...
Rory,

Try:

=ROUND(A1*53%,0)-0.05

--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"Rory" wrote in message
...
* a cell value by 53 % then round up the answer to have .95 on the end.

Thanks
Rory

How to write this formula?
 

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


with @tiscali.co.uk


"Biff" wrote in message
...
=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

"Sandy Mann" wrote in message
...
Rory,

Try:

=ROUND(A1*53%,0)-0.05

--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"Rory" wrote in message
...
* a cell value by 53 % then round up the answer to have .95 on the end.

Thanks
Rory

How to write this formula?
 

"Biff" wrote in message
...

"Rory" wrote in message
...
* a cell value by 53 % then round up the answer to have .95 on the end.

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.
--
David Biddulph

How to write this formula?
 

Yeah, that's another good point.

Now we just need some feedback from the OP to see what they really wanted!

Biff

"David Biddulph" wrote in message
...
"Biff" wrote in message
...

"Rory" wrote in message
...
* a cell value by 53 % then round up the answer to have .95 on the end.

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.
--
David Biddulph