Home |
Search |
Today's Posts |
#1
|
|||
|
|||
HELP...PLEASE...W/ IF/THEN/COPYTO STATEMENT - THANKS!
This is what I am looking to do...I know this is NOT the way to do it, so I
need help as soon as someone can...THANK YOU SOOOOO MUCH! Hope it makes sense! =IF(D2=MA)AND(E2=0-24)THEN(COPY(A1 and A2)TO WORKSHEET2 AT THE END OF LAST ROW) |
#2
|
|||
|
|||
Hi Mel,
Not exactly sure of your question. Assuming Sheet1 D2 contains "MA" and E2 contains a number between 0 and 24. Assume that the last row of data in Sheet2 is row two. Then put the follwoing formulas in A3 and B3 in Sheet2. =IF(AND(Sheet1!$D$2="MA",AND(Sheet1!$E$2=0,Sheet1 !$E$2<25)),Sheet1!A1,"") =IF(AND(Sheet1!$D$2="MA",AND(Sheet1!$E$2=0,Sheet1 !$E$2<25)),Sheet1!A2,"") Is this what your looking for? "Mel" wrote: This is what I am looking to do...I know this is NOT the way to do it, so I need help as soon as someone can...THANK YOU SOOOOO MUCH! Hope it makes sense! =IF(D2=MA)AND(E2=0-24)THEN(COPY(A1 and A2)TO WORKSHEET2 AT THE END OF LAST ROW) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to calculate a sum as one outcome of an IF statement | Excel Worksheet Functions | |||
What statement to use? | Excel Worksheet Functions | |||
How do I fix a circular reference in a financial statement? | Excel Discussion (Misc queries) | |||
7+ nested if statement? | Excel Worksheet Functions | |||
Statement | Excel Worksheet Functions |