Cell completion

  • Thread starter Thread starter Boenerge
  • Start date Start date
B

Boenerge

I have a spreadsheet with cloumns that give a percentage when cells are
completed with a date.
How can I have the cells counted in the percentage if they do not require a
date e.g. if they are not applicable?
Thanks in advance
Jason
 
Hi Jason,

You may elaborate a bit on what has to be calculated under what circumstances?...........

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I have a spreadsheet with cloumns that give a percentage when cells are
| completed with a date.
| How can I have the cells counted in the percentage if they do not require a
| date e.g. if they are not applicable?
| Thanks in advance
| Jason
 
The columns contain dates of when a course has been completed, some people do
not have to complete a particular course so no date is enetered. At the end
of each column a percentage of course completion is calculated. However, as
some people do not have to complete a course and no date is entered then the
percentage never gets to 100%. I wondered if there was anything I could
enter instead of a date but would be counted the same as date so that when
evryone who needs to complete and has then the percentage will reach 100%.
Thanks
Jason
 
All you're doing is calculating the percent of the range that's populated
with numbers (dates).

So, just enter 0's for those situations.
 
Should have thought of that before.
Thanks

Ragdyer said:
All you're doing is calculating the percent of the range that's populated
with numbers (dates).

So, just enter 0's for those situations.
Click to expand...
 
Back
Top