Formula for counting bonus

Waleed

Hi ,

Please find attached screenshot above ..

i would like to create formula to input it in Cloumn [Bonus] to help us to calculate daily bonus for our employee sales as follow ..

(1) if amount in Col [Daily Income] is higher than amount in Col [Target] to calculate the following

Calculate 60% of the difference amount between Daily income and Target .

Example: Date 01/03/2023 the amount in col [Bonus] 4.200$ is 60% of 7.00$ which is difference between 50 and 43.

(2) If amount in Col [Daily Income] is LESS than amount in Col [Target] than not to take any action or count 0.00 as no sales target not reached

Thanks for assistance

Nic Larsen

Try: =IF([Daily Income]@row > Target@row, ([Daily Income]@row - Target@row) * 0.6)

Nic Larsen

Try: =IF([Daily Income]@row > Target@row, ([Daily Income]@row - Target@row) * 0.6)

Waleed

Many Thanks @Nic Larsen

It works , your assistance made our day :)