|
|
|
|
|||||
|
|
|
|
|
|
|||
| Welcome
to Tech Support Forum home to more then 136,000 problems solved. Issues
have included: Spyware, Malware, Virus Issues, Windows, Microsoft,
Linux, Networking, Security, Hardware, and Gaming Getting your
problem solved is as easy as: 1. Registering for a free account 2. Asking your question 3. Receiving an answer Registered members: * See fewer ads. * And much more..
|
| Want to know how to post a question? click here | Having problems with spyware and pop-ups? First Steps |
|
|||||||
| Microsoft Office support MS Office support forum |
 |
|
|
LinkBack | Thread Tools |
11-12-2007, 02:32 AM
|
#1 (permalink) |
|
Registered User
Join Date: Nov 2007
Posts: 1
OS: Windows XP Professional
|
Microsoft Excel 2K3 question.....
Heya, everyone. I'm deployed with the US Airforce and thusly, my resources are rather limited. I have an excel project that I'm working on and involves copying and pasting a formula numerous times. I'm doing an (IF(AND)) function and having trouble getting excel to automatically add the rows in the formula when I drag the columns to the right. It adds a letter to the column instead of a number to the row. For instance....I have the following formula that I want to copy and paste into a new cell:
=IF(AN(F32<U4, F32>U5,F33<U4,F33>U5),1,0) I want it to add 7 rows in the function everytime I drag the column to the right i.e. =IF(AN(F39<U4, F39>U5,F40<U4,F40>U5),1,0) Thanks in advance for the help.. kimmiluv 
Last edited by Kimmiluv; 11-12-2007 at 02:44 AM. |
|
     
|
| Important Information |
|
Join the #1 Tech Support Forum Today - It's Totally Free!
TechSupportForum.com is a leading support website for your computer needs. We offer free, friendly and personalized computer support. Why pay to have your computer fixed when you can do it for free. Join TechSupportforum.com Today - Click Here |
|
| Thread Tools | |
|
|
