i cant figure out what is wrong with my formula

[lilhotch14]

im doin a workbook for bowling payments and i cant get a formula correct. can anyone help?

this is the formula

=IF(B9:G9="Absent",0,IF(F$6="No Bowl",F10,IF(G9="Absent",$AP10+F10,F10+$AQ10)))


AP!0 is the value if absent, and AQ10 is when they are there. when i make cell G9 absent, it becomes 0, when its suppose to be F10+AP10.

do you understand my problem?

 

[PATSYS]

I can say that the expression

=IF(B9:G9="Absent"

in your formula is invalid, unless you are trying to create an array formula (CSE) which I don't think you do.

Try this:

=IF(G9="Absent",$AP10+F10,IF(F$6="No Bowl",F10,(F10+$AQ10)))

 

[lilhotch14]

the +IF(B9:G9="Absent" part im trying to get to be so if B9, C9, D9, E9, F9, & G9 are all "Absent" then i want it to be 0, and if only G9 is absent i want it to be F10+$AP10

 

[acw]

Hi

Try

=IF(COUNTIF(B9:G9,"Absent")=6,0,IF(F$6="No Bowl",F10,IF(G9="Absent",$AP10+F10,F10+$AQ10)))

Tony

 

[lilhotch14]

thx Tony. that worked