DoosanRuss
New Member
- Joined
- Aug 3, 2010
- Messages
- 25
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:
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
(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