Help on "IF" function

  • Thread starter Thread starter Jill
  • Start date Start date
J

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!
 
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
 
Back
Top