# if formula in excel

Highlighted
Occasional Visitor

# if formula in excel

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
Highlighted

# Re: if formula in excel

In D8

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

and then copy it down.

Highlighted

# Re: if formula in excel

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