I have a Job Spec Sheet that i use & I would like to be able to get a
specification based on 4 separate criteria. It would be a useful cross
reference on an area that can easily be done filled in incorrectly. I would
like to do the following:

A1: Overall Height = B1 (Condition 1)
A2: Turntable Height: = B2 (Condition 2)
A3: Flooring: = B3 (Condition 3)
A4: Trailer Type: = B4 (Condition 4)
A5: Rear Opening: = B5 (ANSWER REQUIRED BASED ON ABOVE CONDITIONS)

I hope I have explained myself clearly. Any help would be greatly appreciated.

Thanks in advance

Indicatively, you could try expressing it like this:
=IF(and(Cond1,Cond2,Cond3,Cond4),"Yes","No")
where Cond1/2/34 are your various criteria expressions,
all of which need to simultaneously evaluate to TRUE
for the "Yes" to be returned

Any good? hit YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Rocko" wrote:
I have a Job Spec Sheet that i use & I would like to be able to get a
specification based on 4 separate criteria. It would be a useful cross
reference on an area that can easily be done filled in incorrectly. I would
like to do the following:

A1: Overall Height = B1 (Condition 1)
A2: Turntable Height: = B2 (Condition 2)
A3: Flooring: = B3 (Condition 3)
A4: Trailer Type: = B4 (Condition 4)
A5: Rear Opening: = B5 (ANSWER REQUIRED BASED ON ABOVE CONDITIONS)

I hope I have explained myself clearly. Any help would be greatly appreciated.

Thanks in advance

Thank you Max for your prompt response. Very helpful. That did the trick.

"Max" wrote:

Indicatively, you could try expressing it like this:
=IF(and(Cond1,Cond2,Cond3,Cond4),"Yes","No")
where Cond1/2/34 are your various criteria expressions,
all of which need to simultaneously evaluate to TRUE
for the "Yes" to be returned

Any good? hit YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Rocko" wrote:
I have a Job Spec Sheet that i use & I would like to be able to get a
specification based on 4 separate criteria. It would be a useful cross
reference on an area that can easily be done filled in incorrectly. I would
like to do the following:

A1: Overall Height = B1 (Condition 1)
A2: Turntable Height: = B2 (Condition 2)
A3: Flooring: = B3 (Condition 3)
A4: Trailer Type: = B4 (Condition 4)
A5: Rear Opening: = B5 (ANSWER REQUIRED BASED ON ABOVE CONDITIONS)

I hope I have explained myself clearly. Any help would be greatly appreciated.

Thanks in advance

Delighted, Rocko.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Rocko" wrote in message
...
Thank you Max for your prompt response. Very helpful. That did the trick.