if formula in excel

Copper Contributor

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)

2 Replies

@MelB2020 

Please try this...

 

In D8

=IF(C8>Target,C8*Bonus_rate,0)

 

and then copy it down.

@MelB2020 

Named range Sales starts from the header, thus an error

image.png

If start start it from row #8 it's more correct

image.png

And if correct formula a bit

=IF(Sales>=Target,Sales*Bonus_rate,)

when

image.png