Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function shows repeating decimal?
I have two colums that have simple sum and imsub formulas in them. They
return a repeating number. I would like to have a simple 0.00 number in these cells. How can I do this? I tried to change the format, but apparently it doesn't work on functions. -- |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function shows repeating decimal?
You'll need to provide more information. Format works on any cell, because
it formats the results of the formula. Format can't be used to change the results of a function, however. Let us know what result you're getting, what you want instead, what's "imsub" and how you want the repeating number represented. Regards, Fred "Doug" wrote in message ... I have two colums that have simple sum and imsub formulas in them. They return a repeating number. I would like to have a simple 0.00 number in these cells. How can I do this? I tried to change the format, but apparently it doesn't work on functions. -- |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function shows repeating decimal?
I have the function =IMSUB(C520,B520) in cell D520.
B520 holds the value 990.22 & C520 holds the value 995.04. The function returns the value 4.819999999999994. Changing the format doesn't help any. -- Thank you! "Fred Smith" wrote: You'll need to provide more information. Format works on any cell, because it formats the results of the formula. Format can't be used to change the results of a function, however. Let us know what result you're getting, what you want instead, what's "imsub" and how you want the repeating number represented. Regards, Fred "Doug" wrote in message ... I have two colums that have simple sum and imsub formulas in them. They return a repeating number. I would like to have a simple 0.00 number in these cells. How can I do this? I tried to change the format, but apparently it doesn't work on functions. -- |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Function shows repeating decimal?
Hi Doug,
Are you sure about IMSUB? This function is to calculate the difference between 2 complex numbers. A complex number is a 'number' having a real part and an imaginary part, written as 'a + bi'. Nor B520, nor C520 is a complex number. If you just want to have the difference between 2 values, use C520-B520. Hope this helps. Wkr, JP "Doug" wrote in message ... I have the function =IMSUB(C520,B520) in cell D520. B520 holds the value 990.22 & C520 holds the value 995.04. The function returns the value 4.819999999999994. Changing the format doesn't help any. -- Thank you! "Fred Smith" wrote: You'll need to provide more information. Format works on any cell, because it formats the results of the formula. Format can't be used to change the results of a function, however. Let us know what result you're getting, what you want instead, what's "imsub" and how you want the repeating number represented. Regards, Fred "Doug" wrote in message ... I have two colums that have simple sum and imsub formulas in them. They return a repeating number. I would like to have a simple 0.00 number in these cells. How can I do this? I tried to change the format, but apparently it doesn't work on functions. -- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
repeating function q | Excel Discussion (Misc queries) | |||
repeating function q | Excel Discussion (Misc queries) | |||
Round a repeating decimal from a formula... | Excel Worksheet Functions | |||
cell formated to 2 decimal places but excel shows it as 4 need 2 | Excel Worksheet Functions | |||
Repeating a concatenate function | Excel Worksheet Functions |