formula

[sureyan]

how can i make a formula from the next statement
the publisher pay 16.25% of next sales toward bonus, but if the net sales surpasses $5000 they must pay additional 500.00 on top of the %.

any body can help me with that how can i make a formula to resolve this problem


sureyan

 

[Scott Huish]

Hi, welcome to the board!

Try this:

=(A1*0.1625)+(500*(A1>5000))