| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to write this formula?
* a cell value by 53 % then round up the answer to have .95 on the end.
Thanks Rory |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Help to write a formula using a letter value and a number value | Excel Worksheet Functions | |||
| What is the best way to Write this Formula | Excel Discussion (Misc queries) | |||
| How do I write formula to compare two values and pull the resulta. | Excel Worksheet Functions | |||
| how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Hybrid Mode
