Formula for counting bonus

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


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!