Needing An If And An And
Dec 4, 2008
i need to create an IF and an And formula for the debit columns and credit columns of an income statement and a balance sheet on a 10 column worksheet. The formula for each column will be slightly different but will be the same for every row in the respective column. the formulas must check to see if the account number is associated with an asset, liability, or owner's equity. this will determine if it is a credit or debit balance. my basic goal is to enter all values in unadjusted trial balance and adjustments, while all the other columns fill in automatically.
View 9 Replies
Sep 21, 2007
I am trying to use an IF Condition for multiple options and have forgotten how to make it work. Here is my basic formula:
=IF((B20="CHASE"),SUM(C20:I20))
I need to have several other options in B20 to "CHASE", like AMEX, DISC, BOA and CASH, so I need the B20 result to reflect which of those conditions exist in order to find the sum of C20:I20. I cannot seem to get any configuration to work.
View 9 Replies
View Related
Jan 30, 2008
I've been playing around with the API functions (specifically, InternetOpenURL) to retrieve the contents of an HTTP webpage and store the information within a text file, using Excel VBA. It works great for any "normal" webpage not requiring a "Username" and "Password" login. I can't find any examples on how this is done for a webpage requiring such a login? I've heard you can do this via sending the appropriate cookie to the server, but I can't find any documentation on the web? Does anyone have any idea on how this functionality is achieved?
View 9 Replies
View Related
May 9, 2008
i have a graph that i've linked to let's say cells A1:C150
however, my range could sometimes needs to be shrunken to A1:A100 or A1:A40 etc. (the number of rows that are "active" is determined by cell K27)
i'd like for my graph to automatically adjust depending on the number of rows that are filled within the range above. can this be done with formulas and graph manipulations?
i've put in a formula currently that makes the value of the cells that would return 0 into "" but that doesn't seem to do the trick.
View 9 Replies
View Related
May 14, 2009
I have a table with subtotals that I need to find the largest value for the subtotal results and then return the cell contents for the corresponding row.
I have attempted to use the hlookup function, but keep getting a #ref error (probably because I am just not that familiar with the entire formula requirements).
I attempted to nest in the 'largest' function to the lookup function, but have so far been stymied....
View 14 Replies
View Related
