Jun 29 2020 11:10 PM
Hi, I have been stuck on working out the formula for the below
this is what I have and it isnt working! HELP pls!!
=IF(Sales>=Target,Sales*Bonus_rate)
Jun 29 2020 11:17 PM
Jun 30 2020 12:27 AM
Named range Sales starts from the header, thus an error
If start start it from row #8 it's more correct
And if correct formula a bit
=IF(Sales>=Target,Sales*Bonus_rate,)
when