Nested IF function needed

I'm pretty sure you're going to have to post a SMALL sample file so we can see what you're wanting to do.

Originally Posted by mehmetcik

=IF(A1="YES",10,0)+IF(b1="YES",10,0)+IF(c1="YES",10,0)+IF(d1="YES",10,0)

Where are you getting the value of 10 if TRUE?

You can reduce that to:

=COUNTIF(A1:D1,"Yes")*10

Originally Posted by Petsi

I need to use a nested IF function in cell F8 to figure out the total annual cost for each club member, including the annual membership fee, the Locker Fee and Spa Pass (I will need to use multiple conditions and absolute references to accomplish it)

Maybe this entered in F8 and copied down:

=C8+IF(D8="Yes",C$31)+IF(E8="Yes",C$32)

Originally Posted by Petsi

So I don't have to write something in the FALSE area?

Not in this particular application.

When the logical test is FALSE the IF function will return FALSE by default when the value_if_FALSE argument is omitted. Then, C8+FALSE will coerce the FALSE to numeric 0. So you could end up with C8+0.

Thank you Tony! I am going to find this forum very useful!

You're welcome. Thanks for the feedback!