Hellp Me Excel Help!!!!
Hi Again
Put this in the cell beside the Countif Formula ( I Assume L12) and head it
as Discount. I think it does the Job. There is always other ways.
=IF(L12=170,(L12)*15%,IF(L12=136,(L12)*10%,"No Discount"))
Best
Stewart
"headbanging_Fe" wrote:
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:K125-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%.
|