Formula Combination

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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?
 
Try something like this:

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

Does that help?

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

XL2002, WinXP-Pro
 
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)
 
if any...
--
Randy Street
Rancho Cucamonga, CA


Niek Otten said:
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?
Click to expand...
 
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)
 
Thank you very much...I think we figured it out at the same time! You
assistance is greatly appreaciated!
 
Back
Top