Excell
I have several templates I use at work that I got from template websites. They work rather well for what they do.
BUT
I made a simple template with no formulas just to make a printable worksheet for me to do my daily reports. Now I'd like to go back in to it and insert some formulas.
So the lines read:
(C6) A > Room Rental............................$________
(C7) B > Daily Room Rental.....................$________
(C8) D > Weekly TAXED Room Rental........$________
(C9) C > Weekly TAX EXCEMPT Rm Rental $________
(Please note due to the posting editor limitations, I had to put the dots in to keep everything lined up.)
The formula for the work sheet is: A-B-C=D. The text is in column A. The dollar signs in column B. The numbers in column C.
I click the formula tab and put in the formula and hit enter. Then go back to the home tab. Two things happen. One the formula appears in the C8 cell and two when I enter the numbers it doesn't run the formula and show the output in the C8 cell.
ARRRGGGG What am I doing wrong?
I have several templates I use at work that I got from template websites. They work rather well for what they do.
BUT
I made a simple template with no formulas just to make a printable worksheet for me to do my daily reports. Now I'd like to go back in to it and insert some formulas.
So the lines read:
(C6) A > Room Rental............................$________
(C7) B > Daily Room Rental.....................$________
(C8) D > Weekly TAXED Room Rental........$________
(C9) C > Weekly TAX EXCEMPT Rm Rental $________
(Please note due to the posting editor limitations, I had to put the dots in to keep everything lined up.)
The formula for the work sheet is: A-B-C=D. The text is in column A. The dollar signs in column B. The numbers in column C.
I click the formula tab and put in the formula and hit enter. Then go back to the home tab. Two things happen. One the formula appears in the C8 cell and two when I enter the numbers it doesn't run the formula and show the output in the C8 cell.
ARRRGGGG What am I doing wrong?