Referencing Two Cells

[HappyChappy]

Hope someone can help i have a bonus of .50 paid per hour. it works great apart from if cell C13 is blank then p13 shows 8:00 to allow for a holiday payment for day off.
The problem is that the cell x13 which adds the bonus earned that day returns £4.00 but as it was a day off it should show £0:00 earned for that day

=(((Q13*24)+(R13*24)+(S13*24)))*$A$63 CELL X13
=IF(O13>TIME(8,44,),O13-TIME(0,45,0),O13) CELL Q13
=G13+M13+P13 CELL O13
=IF(C13="","8:00") CELL P13
A63 = £0.50
The trigger needs to be if cell C13 is blank then don't add any bonus to X13 for that day. Can the blank cell c13 be added to the formula in x13 to facilitate this.

Hope this makes sense regards Mark

 

[Fluff]

You can use if for that

=IF(C13="",0, your formula)

 

[HappyChappy]

Hope someone can help i have a bonus of .50 paid per hour. it works great apart from if cell C13 is blank then p13 shows 8:00 to allow for a holiday payment for day off.
The problem is that the cell x13 which adds the bonus earned that day returns £4.00 but as it was a day off it should show £0:00 earned for that day

=(((Q13*24)+(R13*24)+(S13*24)))*$A$63 CELL X13
=IF(O13>TIME(8,44,),O13-TIME(0,45,0),O13) CELL Q13
=G13+M13+P13 CELL O13
=IF(C13="","8:00") CELL P13
A63 = £0.50
The trigger needs to be if cell C13 is blank then don't add any bonus to X13 for that day. Can the blank cell c13 be added to the formula in x13 to facilitate this.

Hope this makes sense regards Mark

You Sir are a true Gent thanks for your assistance the headache is starting to disappear......

 

[Fluff]

Glad to help & thanks for the feedback.