Formula

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

What is the formula to divide a number in a cell by the number of
months to date in the current year?
 
That is the formula I've been using, or =A1/MONTH(NOW()), however bot
are simply carrying the number in A1 to the new cell. Any other ideas?
 
I think I'm missing something. It's January, so you are dividing by 1.
What are you expecting?
kcc
 
Just copying last year's sheet and want to get it to work right for the
future. Last year's had this issue.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Sumproduct 0
Increase Formula Cell Selection Based on Value 8
Return Value Based on Two Others 1
SUM / COUNT formula 3
Age calculation 3
using excel to analyze time series data 8
formula 1
Finding smallest value after certain value in an unsorted range 2

Back
Top