if were talking excel, then you would use an if, almost like in standard programming, its in the formula's menu, and there is help in the help files that will show you the syntax for it.
HTH, inthane----- Original Message ----- From: <james.homme@xxxxxxxxxxxx>
To: <programmingblind@xxxxxxxxxxxxx> Sent: Monday, November 17, 2008 11:51 AM Subject: Re: looking for an app
Hi, Some spreadsheets have a column for indicating that transactions have cleared the bank. Does anyone know how to say something like this in aformula? Let's say you have a number in B1 AND A CLEAR INDICATOR IN C1. Youonly want B2 added to the usable balance if C2 contains the letter X. I haven't found a way to refer to the cell you are pointing to, so I assume that you may need to put a hidden column in your spreadsheet once you set it up, but I'm not sure. Thanks. Jim James D Homme, Usability Engineering, Highmark Inc., james.homme@xxxxxxxxxxxx, 412-544-1810 "The difference between those who get what they wish for and those who don't is action. Therefore, every action you take is a complete success,regardless of the results." -- Jerrold Mundis Highmark internal only: For usability and accessibility: http://highwire.highmark.com/sites/iwov/hwt093/ "The Elf" <inthaneelf@roadr unner.com> To Sent by: programmingblind@xxxxxxxxxxxxx programmingblind- cc bounce@freelists. org Subject Re: looking for an app 11/11/2008 02:51 AM Please respond to programmingblind@ freelists.orgthe way I usually do such things is I start the actual register about threerows down, and if I put this together it would read across with... check#, date, PTOO (pay to the order of), amount, notes below that would be your "working area" up at the top the first row I would select columns "A" through "E" and go to the format menu and merge them giving it a nice fancy lettered E-Check Register (your name here) you could even color the background in and such. then on the second line I would put: "Useable Balance:" without the quotes in column "A" and put a formula in the B column of row 2 like this: =SUM(D4:D1000) that will automatically add all the numbers you enter in the amount column automatically, now here's the goodie, this setup will allow you to enter deposits you make into the account as a positive number "primary deposit (in the PTOO column)" and 1000.00 in the "amount" columnthen if you enter a written check you make it a negative number, cause yourspending it, so 101 | 11/11/08 | what's its name high school | -12.00 | box of pencils (fund raiser) I used a | to break it into the "columns" but if you do this it will add the negative number to the primary deposit amount and put the corrected amount 988 in your B2 usable funds cellyou can also add in other fancies like turning the date column from b4 down(control shift page down) to date format and from D4 down to "currency" to make it even sharper there is a way to make it do things when you hit enter in a specific cell (like putting the current date in the date cell if you hit enter there), but I'd have to look them up again HTH, inthane ----- Original Message ----- From: "Tyler Littlefield" <tyler@xxxxxxxxxxxxx> To: <programmingblind@xxxxxxxxxxxxx> Sent: Monday, November 10, 2008 8:35 PM Subject: Re: looking for an appyeah, I've got works. I was thinking about using excel. If I kept a balance, say a verticle sheet with what it was on the left, and then the values on the right, is there a way to make it automaticallyadd to the total? If I'm going straight down, I can add ranges, but it'd be nice if itwouldjust add the values as they're inserted. Thanks, Tyler Littlefield email: tyler@xxxxxxxxxxxxx web: tysdomain-com Visit for quality software and web design. skype: st8amnd2005 ----- Original Message ----- From: "The Elf" <inthaneelf@xxxxxxxxxxxxxx> To: <programmingblind@xxxxxxxxxxxxx> Sent: Monday, November 10, 2008 9:28 PM Subject: Re: looking for an appdo you have either MSO office or MSO Works, if you have either you can punch out an "electronic checkbook tallier in about as much time as it takes you to type in the column headers, and even have a running "Available Balance" at the top of the thing. HTH, inthane ----- Original Message ----- From: "Tyler Littlefield" <tyler@xxxxxxxxxxxxx> To: <programmingblind@xxxxxxxxxxxxx> Sent: Monday, November 10, 2008 4:52 PM Subject: O-t: looking for an appHello, I've got an assignment for Life management to find a "electronic checkbook." Can anyone make suggestions based on what they use? Thanks, Tyler Littlefield email: tyler@xxxxxxxxxxxxx web: tysdomain-com Visit for quality software and web design. skype: st8amnd2005 __________ View the list's information and change your settings at //www.freelists.org/list/programmingblind__________ View the list's information and change your settings at //www.freelists.org/list/programmingblind__________ View the list's information and change your settings at //www.freelists.org/list/programmingblind__________ View the list's information and change your settings at //www.freelists.org/list/programmingblind __________ View the list's information and change your settings at //www.freelists.org/list/programmingblind
__________View the list's information and change your settings at //www.freelists.org/list/programmingblind