SUMIF function HELP

  • Thread starter Thread starter nick
  • Start date Start date
N

nick

school project..need some help..pay royalty of 2% subject
to maximum of 1000. so i need help to sum it if the
royalty is 1400, how would i add the 1000 and omit the
400?
 
for each sales person Sales in column A

in column b enter

=IF(A1*2%>1000,1000,B2) copy down to all cells

sum the total of column B
 
Back
Top