How to Nest 5 Nested IF(AND functions?

[DoosanRuss]

Good Morning Ladies and Gents
(Using Excel 2003 (XP))

I've been using the board for the past 3 weeks and i'm pleased to say i haven't had to ask, alas it wasn't to last.
am unable to install the add in to post the spreadsheet, so will type it out instead:

A B C
​

1 FALSE 18
2 TRUE = TRUE

just a little background:
A1 = number of floors in a building, 1 = FALSE, 2 = TRUE
C1 = number of showers/person as per building Regulations (going to come from another worksheet)
A2 = ground floor Ablutions (using a check box)
C2 = 1st floor Ablutions (using a check box)
B1 = is blank


B2 Needs to have all of the following formulas:

IF(AND(A1=FALSE,A2=FALSE,C2=FALSE),0,)
IF(AND(A1=FALSE,A2=TRUE,C2=FALSE),SUM(C1),0)
IF(AND(A1=TRUE,A2=TRUE,C2=FALSE),SUM(C1),0)
IF(AND(A1=TRUE,A2=FALSE,C2=TRUE),0,0)
IF(AND(A1=TRUE,A2=TRUE,C2=TRUE),SUM(C1/A5),0)

As always, any help gratefulyl recieved.

Russ

 

[xld]

Try this formula

=IF(AND(NOT(A1),A2,NOT(C2)),C1,0)
+IF(AND(A1,A2,NOT(C2)),C1,0)
+IF(AND(A1,A2,A3),C1/A5,0)

 

[DoosanRuss]

Thanks xld much appreciated, off to read up on 'NOT' now!

Always learning

Russ