| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match then lookup | Excel Worksheet Functions | |||
| adding row to forumla | Excel Discussion (Misc queries) | |||
| Simplify formula | Excel Worksheet Functions | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Linear Mode
