ExcelBanter - Help on "IF" function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Help on "IF" function (https://www.excelbanter.com/excel-worksheet-functions/187184-help-if-function.html)

Jill

Help on "IF" function

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

Help on "IF" function

=A1*B1+IF(A11000000,50000,0)

where A1 is net sales and B1 is percentage
--
Gary''s Student - gsnu200785

"Jill" wrote:

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!

Max

Help on "IF" function

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!

All times are GMT +1. The time now is 11:22 AM.