Formula Combination
 

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)

--
Randy Street
Rancho Cucamonga, CA

Formula Combination
 

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?

--
Kind regards,

Niek Otten

"Randy" wrote in message ...
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)

--
Randy Street
Rancho Cucamonga, CA

Formula Combination
 

Try something like this:

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

Does that help?

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

XL2002, WinXP-Pro


"Randy" wrote:

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)

--
Randy Street
Rancho Cucamonga, CA

Formula Combination
 

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)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=530306

Formula Combination
 

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


"Niek Otten" wrote:

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?

--
Kind regards,

Niek Otten

"Randy" wrote in message ...
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)

--
Randy Street
Rancho Cucamonga, CA

Formula Combination
 

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



"Randy" wrote in message
...
if any...
--
Randy Street
Rancho Cucamonga, CA


"Niek Otten" wrote:

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?

--
Kind regards,

Niek Otten

"Randy" wrote in message
...
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)

--
Randy Street
Rancho Cucamonga, CA

Formula Combination
 

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 Street
Rancho Cucamonga, CA


"Ron Coderre" wrote:

Try something like this:

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

Does that help?

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

XL2002, WinXP-Pro


"Randy" wrote:

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)

--
Randy Street
Rancho Cucamonga, CA

Formula Combination
 

Thank you very much...I think we figured it out at the same time! You
assistance is greatly appreaciated!
--
Randy Street
Rancho Cucamonga, CA


"daddylonglegs" wrote:


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)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=530306