Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Different answers when using cell references as opposed to actual
Why am I sometimes getting different answers when using cell references as
opposed to the actual numbers? IE - B9*I9 vs 500*8.32 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Different answers when using cell references as opposed to actual
leobensmom;210135 Wrote: Why am I sometimes getting different answers when using cell references as opposed to the actual numbers? IE - B9*I9 vs 500*8.32 Hi, which differences do you get ? Is the value in I9 rounded? -- Pecoflyer Cheers - *'Membership is free' (http://www.thecodecage.com)* & allows file upload -faster and better answers *Adding your XL version* to your post helps finding solution faster ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=57672 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Different answers when using cell references as opposed to act
Hi! This is figuring the total cost of shares of stock. My B column is the number of shares and the I column is the cost per share. All numbers were individually entered, not imported or copied. Some times the answer differs by 50 cents, sometimes by 2 cents and sometimes by a dollar or more! I have checked the cell formatting for all and all are formatted to currency except the number of shares which is set to number. It is driving me crazy!!!! "Pecoflyer" wrote: leobensmom;210135 Wrote: Why am I sometimes getting different answers when using cell references as opposed to the actual numbers? IE - B9*I9 vs 500*8.32 Hi, which differences do you get ? Is the value in I9 rounded? -- Pecoflyer Cheers - *'Membership is free' (http://www.thecodecage.com)* & allows file upload -faster and better answers *Adding your XL version* to your post helps finding solution faster ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=57672 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Different answers when using cell references as opposed to act
Excel is not calculating different answers to the same formula. Try increasing
the number of displayed decimal places on your cells to make sure that 8.32 isn't really 8.324268 (or something similar). leobensmom wrote: Hi! This is figuring the total cost of shares of stock. My B column is the number of shares and the I column is the cost per share. All numbers were individually entered, not imported or copied. Some times the answer differs by 50 cents, sometimes by 2 cents and sometimes by a dollar or more! I have checked the cell formatting for all and all are formatted to currency except the number of shares which is set to number. It is driving me crazy!!!! "Pecoflyer" wrote: leobensmom;210135 Wrote: Why am I sometimes getting different answers when using cell references as opposed to the actual numbers? IE - B9*I9 vs 500*8.32 Hi, which differences do you get ? Is the value in I9 rounded? -- Pecoflyer Cheers - *'Membership is free' (http://www.thecodecage.com)* & allows file upload -faster and better answers *Adding your XL version* to your post helps finding solution faster ------------------------------------------------------------------------ Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=57672 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Different answers when using cell references as opposed to act
Glenn wrote:
Excel is not calculating different answers to the same formula. Try increasing the number of displayed decimal places on your cells to make sure that 8.32 isn't really 8.324268 (or something similar). And if that's not it, put a worksheet demonstrating the problem on www.savefile.com and someone will take a look at it. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert relative cell references to absolute cell references via amacro? | Excel Discussion (Misc queries) | |||
How do I get 0 (zero) to register as a value as opposed to blank c | Excel Discussion (Misc queries) | |||
how to replace cell references with actual numbers | Excel Discussion (Misc queries) | |||
How to rename references from range names to cell references | Excel Discussion (Misc queries) | |||
#VALUE in formula as opposed to result | Excel Worksheet Functions |