Pages

Search

Excel Help Forum - Excel General: How to add 1 to a calculated cell if a range of cells are not empty?

Feed2Mail notification - new post on Excel Help Forum - Excel General
Business owner? Manage your customer calls the smart way! 30 day trial for $1 with coupon code F2M65OFF
How to add 1 to a calculated cell if a range of cells are not empty?
This is difficult to describe. I am trying to calculate "Projected yearly gross". The gross is divided by the number of accumulated weeks. So, if we are only 10 weeks into the fiscal year then the gross amount is divided by 10. Currently, I am altering the cell by changing the number each week by...