Ask Your Question
0

How to Calculate for only the 6th Day?

asked 2019-05-05 20:29:31 +0200

Starkman gravatar image

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 flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

answered 2019-05-06 00:20:36 +0200

Starkman gravatar image

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.

edit flag offensive delete link more
0

answered 2019-05-05 22:21:27 +0200

updated 2019-05-05 22:37:01 +0200

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

Format the cell:

image description

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

edit flag offensive delete link more

Comments

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

karolus gravatar imagekarolus ( 2019-05-05 23:23:07 +0200 )edit

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

Gilberto Schiavinatto gravatar imageGilberto Schiavinatto ( 2019-05-05 23:28:27 +0200 )edit

looks better ;-)

karolus gravatar imagekarolus ( 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.

Starkman gravatar imageStarkman ( 2019-05-06 00:17:51 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-05-05 20:29:31 +0200

Seen: 23 times

Last updated: May 06