# How to Calculate for only the 6th Day?

Greetings,

If I work six days in a row (A1:A6) in any given week, I get 1.5 times my regular pay for that sixth day alone (again, it has to be six days in a row in each week to qualify for that extra pay).

How do I have Calc look to see if all six days have hours and then calculate the six day's hours at 1.5 it's normal rate of pay per hour?

Thanks.

edit retag close merge delete

Sort by » oldest newest most voted

Going with what I got here, I've come up with this, which worked: =IF(COUNTBLANK(F5:F10)>=1,0,(1.5*F10)).

Thanks much, all.

more

=IF(COUNTA(A1:A6)=6;SUM(A1:A6)*1,5;SUM(A1:A6))

Format the cell:

Do not use drag hours, it adds 1 more day per cell spent.

more

@Gilberto Schiavinatto: wrong Formula, the 6th day only should be multplied by 1.5

( 2019-05-05 23:23:07 +0200 )edit

=IF(COUNTA(A1:A6)=6;SUM(A1:A5)+(A6*1,5);SUM(A1:A6))

( 2019-05-05 23:28:27 +0200 )edit

looks better ;-)

( 2019-05-05 23:33:07 +0200 )edit

Thanks very much! With what I got here, I went with this, which worked: =IF(COUNTBLANK(F5:F10)>=1,0,(1.5*F10))

Thanks very much for the help.

( 2019-05-06 00:17:51 +0200 )edit