Re: query re excell
If he wants to subtract cell 22 from 12, shouldn't it read (=b12-b22) On 10/24/2016 8:06 PM, Richard Jarvis via Talk wrote: You might want to write your formula like this (=b22-b12) this should do the trick. Rick On 10/23/2016 9:40 PM, Don Smith via Talk wrote: Hi Folks: Although I am running an older version of ms excell, I think the adding and subtracting between 2 cells should be the same. What I need to do is: Subtract cell b22 from cell 12 where cell 22 is $3800.00 and cell 12 is $3900.00 thought the formula Was equal sum(c39b22) But id does not work Thanks Don ___ Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of Ai Squared. For membership options, visit http://lists.window-eyes.com/options.cgi/talk-window-eyes.com/r.jarvis53%40hotmail.com. For subscription options, visit http://lists.window-eyes.com/listinfo.cgi/talk-window-eyes.com List archives can be found at http://lists.window-eyes.com/private.cgi/talk-window-eyes.com . ___ Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of Ai Squared. For membership options, visit http://lists.window-eyes.com/options.cgi/talk-window-eyes.com/carogsmith%40embarqmail.com. For subscription options, visit http://lists.window-eyes.com/listinfo.cgi/talk-window-eyes.com List archives can be found at http://lists.window-eyes.com/private.cgi/talk-window-eyes.com ___ Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of Ai Squared. For membership options, visit http://lists.window-eyes.com/options.cgi/talk-window-eyes.com/archive%40mail-archive.com. For subscription options, visit http://lists.window-eyes.com/listinfo.cgi/talk-window-eyes.com List archives can be found at http://lists.window-eyes.com/private.cgi/talk-window-eyes.com
Re: query re excell
You might want to write your formula like this (=b22-b12) this should do the trick. Rick On 10/23/2016 9:40 PM, Don Smith via Talk wrote: > Hi Folks: > > Although I am running an older version of ms excell, I think the adding and > subtracting between 2 cells should be the same. > > > > What I need to do is: > > > > Subtract cell b22 from cell 12 where cell 22 is $3800.00 and cell 12 is > $3900.00 > > > > thought the formula Was equal sum(c39b22) > > But id does not work > > > > Thanks > > Don > > > > ___ > Any views or opinions presented in this email are solely those of the author > and do not necessarily represent those of Ai Squared. > > For membership options, visit > http://lists.window-eyes.com/options.cgi/talk-window-eyes.com/r.jarvis53%40hotmail.com. > For subscription options, visit > http://lists.window-eyes.com/listinfo.cgi/talk-window-eyes.com > List archives can be found at > http://lists.window-eyes.com/private.cgi/talk-window-eyes.com > . > ___ Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of Ai Squared. For membership options, visit http://lists.window-eyes.com/options.cgi/talk-window-eyes.com/archive%40mail-archive.com. For subscription options, visit http://lists.window-eyes.com/listinfo.cgi/talk-window-eyes.com List archives can be found at http://lists.window-eyes.com/private.cgi/talk-window-eyes.com
RE: query re excell
You need to write that as: =(b12-b22) You don't want the Sum -Original Message- From: Talk [mailto:talk-bounces+shannon=bartchroofing@lists.window-eyes.com] On Behalf Of Don Smith via Talk Sent: Sunday, October 23, 2016 9:41 PM To: 'Window-Eyes Discussion List' Subject: query re excell Hi Folks: Although I am running an older version of ms excell, I think the adding and subtracting between 2 cells should be the same. What I need to do is: Subtract cell b22 from cell 12 where cell 22 is $3800.00 and cell 12 is $3900.00 thought the formula Was equal sum(c39b22) But id does not work Thanks Don ___ Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of Ai Squared. For membership options, visit http://lists.window-eyes.com/options.cgi/talk-window-eyes.com/shannon%40bart chroofing.com. For subscription options, visit http://lists.window-eyes.com/listinfo.cgi/talk-window-eyes.com List archives can be found at http://lists.window-eyes.com/private.cgi/talk-window-eyes.com ___ Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of Ai Squared. For membership options, visit http://lists.window-eyes.com/options.cgi/talk-window-eyes.com/archive%40mail-archive.com. For subscription options, visit http://lists.window-eyes.com/listinfo.cgi/talk-window-eyes.com List archives can be found at http://lists.window-eyes.com/private.cgi/talk-window-eyes.com
Re: query re excell
First of all, c39b22 will be interpret ed as one big cell reference - and that is an invalid one too. Secondly, you have to tell Excel, what to do with the two cells, and you did not. You sure told it to sum, but what kind of summing. OK, then, ExeDavidcel should not name it sum, but more likely calculate. Solution is: iInsert a standard operator, between the two cell references, and see if that doesn't do the job. All four standard operators, can be used. Plus, Minus, division (the normal slash), and multiplication (the asterisc or star-symbol). How about this formula: =Sum(C39-b22) HTH, On 10/24/2016 4:40 AM, Don Smith via Talk wrote: > Hi Folks: > > Although I am running an older version of ms excell, I think the adding and > subtracting between 2 cells should be the same. > > > > What I need to do is: > > > > Subtract cell b22 from cell 12 where cell 22 is $3800.00 and cell 12 is > $3900.00 > > > > thought the formula Was equal sum(c39b22) > > But id does not work > > > > Thanks > > Don > > > > ___ > Any views or opinions presented in this email are solely those of the author > and do not necessarily represent those of Ai Squared. > > For membership options, visit > http://lists.window-eyes.com/options.cgi/talk-window-eyes.com/trailerdavid%40hotmail.com. > For subscription options, visit > http://lists.window-eyes.com/listinfo.cgi/talk-window-eyes.com > List archives can be found at > http://lists.window-eyes.com/private.cgi/talk-window-eyes.com > . > ___ Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of Ai Squared. For membership options, visit http://lists.window-eyes.com/options.cgi/talk-window-eyes.com/archive%40mail-archive.com. For subscription options, visit http://lists.window-eyes.com/listinfo.cgi/talk-window-eyes.com List archives can be found at http://lists.window-eyes.com/private.cgi/talk-window-eyes.com
