Hellp Me Excel Help!!!! pt 2

[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)) ???

 

[stew]

Hi again PT 2
This works in N40
=IF(COUNTIF(G40:K40,"d")=5,(M40*85%),IF(COUNTIF(G40:K40,"d")=4,(M40*90%),"No
Discount"))

I do not undersand what F6 has to do with it

Best Stew

 

[headbanging_Fe]

thanks

Hi again PT 2
This works in N40
=IF(COUNTIF(G40:K40,"d")=5,(M40*85%),IF(COUNTIF(G40:K40,"d")=4,(M40*90%),"No
Discount"))

I do not undersand what F6 has to do with it

Best Stew