Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I have a problem with a formulae.
i am trying to make a formulae to show the cost of a certain cell.
One cell gets it's figure by calculating a percentage to reurn a value. Eg 54% of 30000 is 13,637. When i try to * this cell by an amount it sometimes returns 3 or 4 pound more than what it should be. I have tried to set the cells to no decimal places but i's not making a difference. Help would be greatly appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
I have a problem with a formulae.
Formatting a cell doesn't change its underlying value. You probably have a
value of something like 13637.4215 in the cell. If you want to get rid of the value after the decimal point, you must round, as in: =round(30000*54%,0) which, by the way, is 16200, not 13637. Regards, Fred. "James" wrote in message ... i am trying to make a formulae to show the cost of a certain cell. One cell gets it's figure by calculating a percentage to reurn a value. Eg 54% of 30000 is 13,637. When i try to * this cell by an amount it sometimes returns 3 or 4 pound more than what it should be. I have tried to set the cells to no decimal places but i's not making a difference. Help would be greatly appreciated |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
I have a problem with a formulae.
Cheers that sorted it no problem. Thanks
"Fred Smith" wrote: Formatting a cell doesn't change its underlying value. You probably have a value of something like 13637.4215 in the cell. If you want to get rid of the value after the decimal point, you must round, as in: =round(30000*54%,0) which, by the way, is 16200, not 13637. Regards, Fred. "James" wrote in message ... i am trying to make a formulae to show the cost of a certain cell. One cell gets it's figure by calculating a percentage to reurn a value. Eg 54% of 30000 is 13,637. When i try to * this cell by an amount it sometimes returns 3 or 4 pound more than what it should be. I have tried to set the cells to no decimal places but i's not making a difference. Help would be greatly appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulae: Paste value formulae after doing an average operation | Excel Discussion (Misc queries) | |||
Array formulae - problem | Excel Discussion (Misc queries) | |||
age formulae | Excel Discussion (Misc queries) | |||
Searching TEXT in formulae, rather than results of formulae | Excel Worksheet Functions | |||
Formulae | Excel Discussion (Misc queries) |