D
DEVONA
I AM WORKING ON A SPREADSHEET TO TRACK MONTHLY SALES. I WANT TO DO AN IF
STATEMENT THAT WILL TELL ME IF SALES ARE UP OR DOWN COMAPAIRING THE LAST
MONTH TO THE PRIOR MONTH. I KNOW HOW TO DO THE IF STATEMENT. BUT WHAT I DONT
KNOW HOW TO DO IS SET IT UP TO UPDATE EACH TIME A NEW MONTH ENDS.
FOR EXAMPLE I WANT TO COMPARE SALES FOR DEC WITH NOV WERE THEY UP OR DOWN.
NOW WHEN JANUARY ENDS I WANT TO COMPARE JANUARY WITH DECEMBER. I WOULD LIKE
THE IF STATEMENT TO UPDATE TO TAKE THE NEW INFORMATION AND COMPARE IT WITH
THE PREVIOUS MONTH WITH OUT HAVING TO GO IN AND ADJUST THE IF STATEMENT EACH
TIME. CAN THIS BE DONE AND IF SO HOW? I AM USING EXCEL 2003 AT THIS POINT AND
TIME.
STATEMENT THAT WILL TELL ME IF SALES ARE UP OR DOWN COMAPAIRING THE LAST
MONTH TO THE PRIOR MONTH. I KNOW HOW TO DO THE IF STATEMENT. BUT WHAT I DONT
KNOW HOW TO DO IS SET IT UP TO UPDATE EACH TIME A NEW MONTH ENDS.
FOR EXAMPLE I WANT TO COMPARE SALES FOR DEC WITH NOV WERE THEY UP OR DOWN.
NOW WHEN JANUARY ENDS I WANT TO COMPARE JANUARY WITH DECEMBER. I WOULD LIKE
THE IF STATEMENT TO UPDATE TO TAKE THE NEW INFORMATION AND COMPARE IT WITH
THE PREVIOUS MONTH WITH OUT HAVING TO GO IN AND ADJUST THE IF STATEMENT EACH
TIME. CAN THIS BE DONE AND IF SO HOW? I AM USING EXCEL 2003 AT THIS POINT AND
TIME.