Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
function to return day in the form "Monday", "Tuesday" etc given . | Excel Worksheet Functions | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel |