Help on "IF" function

[Jill]

I need the formaula for this statement... "If the net sales of A is greater
than $1,000,000, then they must pay an additional $50,000 on top of
percentage". I currently have Net "Sales * Royalties (%)" in the the cell.
Please Help!

 

[Gary''s Student]

=A1*B1+IF(A1>1000000,50000,0)

where A1 is net sales and B1 is percentage

 

[Max]

Assuming sales in A2 down, with royalty = 5%,
then something like this in B2:
=IF(A2>10^6,A2*5%+50000,A2*5%)
Copy down