Formula Combination

[Randy]

Any one have any ideas how I might be able to combine the following into one
formula?

=IF('Check-In'!H6=TRUE,0,S8)
=IF('Check-In'!I6=TRUE,0,S8)
=IF('Check-In'!J6=TRUE,0,S8)

 

[Niek Otten]

What do you require? If any of H6, I6, J6 = True.. or if all of etc.?
And, is TRUE meant to be a text or the Boolean result of a formula?

 

[Ron Coderre]

Try something like this:

=IF(COUNTIF(H6:J6,TRUE),S8,0)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro

 

[daddylonglegs]

There are several ways but it depends upon the results you want.
Assuming you want to return zero if any of the 3 is true, S8 otherwise

=IF(COUNTIF('Check-In'!H6:J6,TRUE),0,S8)

 

[Randy]

if any...
--
Randy Street
Rancho Cucamonga, CA

What do you require? If any of H6, I6, J6 = True.. or if all of etc.?
And, is TRUE meant to be a text or the Boolean result of a formula?

 

[JethroUK©]

=IF(OR('Check-In'!H6=TRUE,'Check-In'!I6=TRUE,'Check-In'!J6=TRUE),0,S8)

if any...

 

[Randy]

Thank you very much...with a little tweak it worked like a charm!! here is
what i ended up with....
=IF(COUNTIF('Check-In'!H6:J6,TRUE),S8,0)

 

[Randy]

Thank you very much...I think we figured it out at the same time! You
assistance is greatly appreaciated!