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

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)

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" <[email protected]> wrote in message news:[email protected]...
> 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

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

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" <[email protected]> wrote in message news:[email protected]...
> > 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
>
>
>

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

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



"Randy" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> > > 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
> >
> >
> >

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
>
>