Home |
Search |
Today's Posts |
#1
|
|||
|
|||
round up a percentage formular
Hello
I have managed to put a formular in that lets me add a percentage on cost to an amount and still come out in price rather than a percentage, that is all good but please can you help me by telling me now how i can make that price round up so it is 5.14 rather than 5.1436 Many Thanx -- Rose |
#2
|
|||
|
|||
Do you want rounding?
=ROUND(5.1436,2) If 5.1436 really should be transformed into 5.15, use: =CEILING(5.1436,.01) "RoseR" wrote: Hello I have managed to put a formular in that lets me add a percentage on cost to an amount and still come out in price rather than a percentage, that is all good but please can you help me by telling me now how i can make that price round up so it is 5.14 rather than 5.1436 Many Thanx -- Rose |
#3
|
|||
|
|||
thank you, it would be the =CEILING one, how would i do that for a whole
colum with all differnt prices ? -- Rose "Duke Carey" wrote: Do you want rounding? =ROUND(5.1436,2) If 5.1436 really should be transformed into 5.15, use: =CEILING(5.1436,.01) "RoseR" wrote: Hello I have managed to put a formular in that lets me add a percentage on cost to an amount and still come out in price rather than a percentage, that is all good but please can you help me by telling me now how i can make that price round up so it is 5.14 rather than 5.1436 Many Thanx -- Rose |
#4
|
|||
|
|||
Copy it into an adjacent cell, like
=CEILING(A1,.01) and copy down all rows. -- HTH Bob Phillips "RoseR" wrote in message ... thank you, it would be the =CEILING one, how would i do that for a whole colum with all differnt prices ? -- Rose "Duke Carey" wrote: Do you want rounding? =ROUND(5.1436,2) If 5.1436 really should be transformed into 5.15, use: =CEILING(5.1436,.01) "RoseR" wrote: Hello I have managed to put a formular in that lets me add a percentage on cost to an amount and still come out in price rather than a percentage, that is all good but please can you help me by telling me now how i can make that price round up so it is 5.14 rather than 5.1436 Many Thanx -- Rose |
#5
|
|||
|
|||
modify the cell that has your original formula in it - the one in which you
add a % to cost to come up with a price, then copy it to all the other cells with the same formula =CELING(your formula, .01) The easiest way to modify the existing formula is to select the cell and press the F2 key. This puts you in edit mode at the end of the formula. Type in the new characters for the end of the formula - ,.01) - then cursor left and insert these characters between the equals sign and the start of your current formula - CEILING( - then press Enter "RoseR" wrote: thank you, it would be the =CEILING one, how would i do that for a whole colum with all differnt prices ? -- Rose "Duke Carey" wrote: Do you want rounding? =ROUND(5.1436,2) If 5.1436 really should be transformed into 5.15, use: =CEILING(5.1436,.01) "RoseR" wrote: Hello I have managed to put a formular in that lets me add a percentage on cost to an amount and still come out in price rather than a percentage, that is all good but please can you help me by telling me now how i can make that price round up so it is 5.14 rather than 5.1436 Many Thanx -- Rose |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Round Up to Nearest 10 | Excel Worksheet Functions | |||
Round time to nearest quarter hr | Excel Worksheet Functions | |||
How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions | |||
percentage of sales | Excel Worksheet Functions | |||
Round Time | Excel Worksheet Functions |