You could use this as the CF formula in B3:
=OR(A3="Pipe",A3="Duct",A3="Tray")
any good? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Steve HKG" wrote:
Hi Max, Thanks!
If I have multiple parameters, i.e. "Pipe","Duct","Tray", how can I join
that together in the IF statement, to be true?
Cheers,
Ando