can any one please short this?

[waqasgul]

Dear All Friends,
need help to short this sheet for working, little introduction
to this sheet, this is our incentive sheet, which i update on daily
bases, on daily bases i put every employee output pcs,
and in the end total of every 10 days, because we are offering
every 10 days incentive on total pcs, now i am totaling targets and totaling
output and than if someone achieving there target than they getting
incentive and absent days will deduct from there incentive,
i want that if someone haven't getting incentive than show 0.

can anyone please short this sheet/ suggestion? because i have 100 above employees, that's why to save my time and work in better way? i feel that this is not a good design for incentive sheet, if someone can give suggestion to be having good and nice design sheet??

thanks to all

 

[arnelgp]

just expand your formula there:

=IF((IF(Z12>=Y12,D12*8)-(D12*AI12)+(AA12*0.2))<1, 0, IF(Z12>=Y12,D12*8)-(D12*AI12)+(AA12*0.2))

 

[waqasgul]

just expand your formula there:

=IF((IF(Z12>=Y12,D12*8)-(D12*AI12)+(AA12*0.2))<1, 0, IF(Z12>=Y12,D12*8)-(D12*AI12)+(AA12*0.2))

Thank u so much for the correction in formula.. any advice about the sheet? to make it in a better way? to reduce my time and to give a better look to my incentive sheet?