Populate Cell Based on IF

[laundry125]

I am using the following formula...

=IF(Sheet1!B7="Tom",Sheet1!B4,0)

I would like to add... OR Sheet1!B5="Tom"

To summarize, if the text in cells Sheet1!B5, Sheet1!B6 or Sheet1! B7 = Tom, then copy Sheet1!B4

How do I add OR and how many OR's can I use?

Thank You.

[shg]

Maybe =IF(or( Sheet1!B5:B7="Tom"), Sheet1!B4, 0)

This is an array formula, meaning it MUST be confirmed with Ctrl+Shift+Enter, not just Enter. (With the cursor in the formula bar, hold down Ctrl and Shift, then press Enter.) You'll know you did it correctly if curly braces appear around the formula in the Formula Bar; you cannot type in the braces directly.

[laundry125]

WHen I enter that formula it seems to want B5, B6 AND B7 to =TOM,
rather than B5, B6 OR B7

[shg]

Change the OR to AND.

[laundry125]

Ctrl+Shift+Enter was the missing link.
Thank You.

[shg]

You're welcome.

Array formulas are a whole new world, but they can be very slow to calculate. Use only as necessary.

[laundry125]

Are there other options rather than using array formuals then? I will probably use more of that same type of formula while creating this series of workbooks.

[ChemistB]

To go back to your original question, the OR function (and the AND function) starts with the OR and then all the arguments in parenthesis

Please Login or Register  to view this content.

Excel allows up to 30 arguments.

ChemistB