if formula returns a zero value, do another calculation

[petelomax]

Hi

What i am after is when a formula returns a value of zero, i need it to look at another figure elsewhere and re-do the calculation. Looking at the attachment will explain this further. Cell D4 has no figure in it, therefore J4 will not. instead i need J4 to calculate the total pay based on the hourly rate of £7 per hour multiplied by the minutes taken.test.xlsx

[JieJenn]

Enter =IF(D4="",7*(I4/60),F4)

[petelomax]

Hi JieJenn

This works great thank you very much for your reply!

Pete