Good afternoon All, I am struggling with creating a formula and can not seem to find the help I need. I usually come to this site for help from the forum as a guest but this time I am stuck. I am using a SUMIF formula as follows
=SUMIF($B$4:$B$54,"BUK15526",$Q$4:Q$79) to total a sale.
However, I have a customer that I need to apply discount to if a line item of an order is above a certain value, lets say 5% if equal to or greater than £1000.00 and then 10% if equal to or greater than £5000. The closest I have got is the below but is not right.
=SUMIF($B$4:$B$54,"BUK15528",$Q$4:$Q$79)*AND($D$4:$D$100="CUSTOMER NAME")*AND($Q$4:$Q$100>=1000)*0.95*OR($Q$4:$Q$100>=5000)*0.9
Please not this is customer specific so I require the formula to still work for all other customers as the first formula does.
Thank you in advance for assisting with correcting this.
=SUMIF($B$4:$B$54,"BUK15526",$Q$4:Q$79) to total a sale.
However, I have a customer that I need to apply discount to if a line item of an order is above a certain value, lets say 5% if equal to or greater than £1000.00 and then 10% if equal to or greater than £5000. The closest I have got is the below but is not right.
=SUMIF($B$4:$B$54,"BUK15528",$Q$4:$Q$79)*AND($D$4:$D$100="CUSTOMER NAME")*AND($Q$4:$Q$100>=1000)*0.95*OR($Q$4:$Q$100>=5000)*0.9
Please not this is customer specific so I require the formula to still work for all other customers as the first formula does.
Thank you in advance for assisting with correcting this.