Prev: macros button
Next: emailing worksheet
From: Joe on 1 May 2010 12:36 This is my Formula =(a1a2) a1 = 37.5 a2 = 10 response should be 27.5 But response comes to 28 and under format the sample says 27.5 why ?
From: Gord Dibben on 1 May 2010 12:43 You either have a typo or don't understand arithmetic. 37.5  10 is 27.5 10  37.5 is 27.5 You will see 28 or 28 if formatted to no DP Gord Dibben MS Excel MVP On Sat, 1 May 2010 09:36:01 0700, Joe <Joe(a)discussions.microsoft.com> wrote: >This is my Formula > > =(a1a2) > >a1 = 37.5 >a2 = 10 > >response should be 27.5 > >But response comes to 28 and under format the sample says 27.5 why ?
From: Roger Govier on 1 May 2010 12:46 Hi Joe The result should be 27.5, not 27.5 for the way tyou have expressed the formula. In this case, you don't need the parentheses around the cell references, just =A1A2 would suffice. The reason you are seeing 28, is due to cell formatting. Right click the cell>Format>Cell>Number>and chose 1 decimal place (or whatever you require)  Regards Roger Govier Joe wrote: > This is my Formula > > =(a1a2) > > a1 = 37.5 > a2 = 10 > > response should be 27.5 > > But response comes to 28 and under format the sample says 27.5 why ? >
From: JLatham on 1 May 2010 13:14 Sounds like that the formatting for the cell with the formula in it is simply set up not to display any decimals, forcing 27.5 to display as 28. As for "response should be 27.5"  no, not as you've shown it: A1 = 37.5 A2 = 10 formula =(a1a2) is same as =(37.5  10) is same as 27.5 to get 27.5 the formula would need to be =a2a1 or =(a2a1) "Joe" wrote: > This is my Formula > > =(a1a2) > > a1 = 37.5 > a2 = 10 > > response should be 27.5 > > But response comes to 28 and under format the sample says 27.5 why ? >
From: Billns on 1 May 2010 18:46 On 5/1/2010 10:14 AM, JLatham wrote: > Sounds like that the formatting for the cell with the formula in it is simply > set up not to display any decimals, forcing 27.5 to display as 28. > As for "response should be 27.5"  no, not as you've shown it: > A1 = 37.5 > A2 = 10 > formula =(a1a2) > is same as =(37.5  10) > is same as 27.5 > to get 27.5 the formula would need to be =a2a1 or =(a2a1) > > > "Joe" wrote: > >> This is my Formula >> >> =(a1a2) >> >> a1 = 37.5 >> a2 = 10 >> >> response should be 27.5 >> >> But response comes to 28 and under format the sample says 27.5 why ? >> We all make missteaks! I suspect Joe is banging his head against the monitor and saying "Doh!" Bill

Pages: 1 Prev: macros button Next: emailing worksheet 