Assuming sales in A2 down, with royalty = 5%,
then something like this in B2:
=IF(A210^6,A2*5%+50000,A2*5%)
Copy down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jill" wrote:
I need the formula 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!