Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can anyone help ?
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can anyone help ?
Hello - If you have a total somewhere (I would suggest inserting a column on
your spreadsheet titled Total and then entering a "1" if the person is going to be out, then total the column of "1"s by entering "=SUM(x:y)" where x=first cell in the range, and y=last cell in the range), in a different cell, enter "=.1*z" where z equals the total of people out of the office. I hope that helps! Angie -- This posting is provided "AS IS" with no warranties, and confers no rights. "John" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|