software

I have created a holiday planner for staff with in are company

and i need a formula that gives us only 10% of the total number of staff are
off on holiday.

would be greatful if anyone could help.

Hello - If you have a total somewhere (I would suggest inserting a column on
your spreadsheet titled Total and then entering a quot;1quot; if the person is going
to be out, then total the column of quot;1quot;s by entering quot;=SUM(x:y)quot; where
x=first cell in the range, and y=last cell in the range), in a different
cell, enter quot;=.1*zquot; where z equals the total of people out of the office.

I hope that helps!
Angie
--
This posting is provided quot;AS ISquot; with no warranties, and confers no rights.quot;Johnquot; wrote:

gt; I have created a holiday planner for staff with in are company
gt;
gt; and i need a formula that gives us only 10% of the total number of staff are
gt; off on holiday.
gt;
gt; would be greatful if anyone could help.