excelwnbCopper ContributorDec 13, 2019SolvedExcel formula multiple IF or possible and/or functions. Trying to calculate if C8 is 0,0, if C8 is between 11-20 then C8*50, if C8 is > 20 then C8*100 plus the 500 from C8*10. end result is a $50 bonus per file on...Show MorePReaganDec 13, 2019Hello excelwnb, Assuming there is no bonus between 0 and 10 units:=IF(C8>20,(C8-20)*100+500, IF(C8>=11,(C8-10)*50,0))
PReaganDec 13, 2019Hello excelwnb, Assuming there is no bonus between 0 and 10 units:=IF(C8>20,(C8-20)*100+500, IF(C8>=11,(C8-10)*50,0))
PReaganDec 13, 2019Hello excelwnb, Assuming there is no bonus between 0 and 10 units:=IF(C8>20,(C8-20)*100+500, IF(C8>=11,(C8-10)*50,0))
PReaganBronze ContributorDec 13, 2019Hello excelwnb, Assuming there is no bonus between 0 and 10 units:=IF(C8>20,(C8-20)*100+500, IF(C8>=11,(C8-10)*50,0))
