Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
On Sep 11, 1:00 pm, Lisa wrote:
Using Excel 2003, and having a problems using formulas and then copying those formulas and using auto fill. This is so frustrating. It would be helpful is someone could review the worksheet to see what I am doing wrong. You could mail it to me: joeu2004 "at" hotmail.com . If it's not complicated, I would be happy to take look at it. But before you resort to that, consider this WAG: check whether you are using absolute and relative references correctly for your application. Be sure to use references of the form $A$1 when you want all the formulas to refer to that cell. Be sure to use references of the form $A1 and A$1 when it makes sense for copying formulas down a row or across columns. And of course, be sure to use references of the form A1 when you want the cell to track row and column changes during copy operations. HTH. If not, feel free to mail the spreadsheet to me for look-see. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
Combine logical formulas "if", "and", "or" | Excel Discussion (Misc queries) | |||
Combining formulas, "and" & "or" to verify content of multiple cel | Excel Discussion (Misc queries) | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |