H
headbanging_Fe
i done the previous problem and thank you to everyone.
i have to make a discount on if attendance is 5 days then they get 15% and
if the attendance is 4 days 10% and less 0.
=(COUNTIF(G12:K12,"D")*34,if=G12:K12>5-0.15,if=G12:K12<=4,-0.10,0)+(COUNTIF(G12:K12,"M")*20)+(COUNTIF(G12:K12,"A")*15)
i used the countif statement to work out the formula, but it doesnt work. im
thinking off doing an if statement to see if it works.
=IF(G25<4, (10/100),(15/100))-M25
this one is giving me the right answer but the answer is with a minus.
the formula is meant to say when the children attend less than four days
takeaway 10% otherwise 15%.
if they attend 5 full days two of the days are discounted at 15%. if they
attend 4 full days then 1 day is discounted at 10%.
i tried out a couple formulas
=M25-IF(G25<4, (10/100),(15/100))
=M26-IF(G26<=4, (10/100),IF(G26:K26>=5,15/100,0))
=(COUNTIF(G12:K12,"D")*34)+(COUNTIF(G12:K12,"M")*20)+(COUNTIF(G12:K12,"A")*15)-0.15
these formulas work but it is taking off some money when it shouldnt. but im
sure it has to be a if statement for it to use the 3 conclusions.
i am not sure how to do the formula.
=if(countif,G40:K40,"D")<=5,((M40-0.15)*(F6*2))/100,if(countif(G40:K40,"D")<=4,((M40-0.10)*(F6*1)/100)) ???
i have to make a discount on if attendance is 5 days then they get 15% and
if the attendance is 4 days 10% and less 0.
=(COUNTIF(G12:K12,"D")*34,if=G12:K12>5-0.15,if=G12:K12<=4,-0.10,0)+(COUNTIF(G12:K12,"M")*20)+(COUNTIF(G12:K12,"A")*15)
i used the countif statement to work out the formula, but it doesnt work. im
thinking off doing an if statement to see if it works.
=IF(G25<4, (10/100),(15/100))-M25
this one is giving me the right answer but the answer is with a minus.
the formula is meant to say when the children attend less than four days
takeaway 10% otherwise 15%.
if they attend 5 full days two of the days are discounted at 15%. if they
attend 4 full days then 1 day is discounted at 10%.
i tried out a couple formulas
=M25-IF(G25<4, (10/100),(15/100))
=M26-IF(G26<=4, (10/100),IF(G26:K26>=5,15/100,0))
=(COUNTIF(G12:K12,"D")*34)+(COUNTIF(G12:K12,"M")*20)+(COUNTIF(G12:K12,"A")*15)-0.15
these formulas work but it is taking off some money when it shouldnt. but im
sure it has to be a if statement for it to use the 3 conclusions.
i am not sure how to do the formula.
=if(countif,G40:K40,"D")<=5,((M40-0.15)*(F6*2))/100,if(countif(G40:K40,"D")<=4,((M40-0.10)*(F6*1)/100)) ???