on the attached speadsheet i have calculated the percentage sick, but i nee now to calculate the percentage in aswell can anyone help
sorry for double posting as last one did not include the zip file rquired
on the attached speadsheet i have calculated the percentage sick, but i nee now to calculate the percentage in aswell can anyone help
sorry for double posting as last one did not include the zip file rquired
Try this in X5 and copy down
=--IF(T5,U5/T5) this will return zero% rather than the #DIV/0 error
oldchippy
-------------
![]()
![]()
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks