Hi guys,

I am new to this forum and not an excel master however i need help with a formula... i will try my best to explain...

If A = between B ($5,000) & C ($9,999) it will equal D ($350), or if A = between E ($10,000) & F ($19,999) it will equal G ($450), or if A = between H ($20,000) & I ($29,999) it will equal J ($600), or if A = between K ($30,000) & L ($35,000) it will equal M ($750)

I hope this makes sense... i need help with a formula..

so far i have... =IF(AND(A39>=A45,A39<=B45),"$350","No") and it works however i have 3 other sums in need to add in to this formula and i dont know how to figure it out.