Re: query re excell

2016-10-24 Thread Carol and Roger via Talk
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

Re: query re excell

2016-10-24 Thread Richard Jarvis via Talk
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

RE: query re excell

2016-10-24 Thread Shannon via Talk
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

Re: query re excell

2016-10-24 Thread David via Talk
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

query re excell

2016-10-23 Thread Don Smith via Talk
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