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
