Return the sole true value from a series of formuals

[alanos206]

Hi,

I have a series of formulas where based on a set of selected values only one of the formulas will return a "TRUE" result. I'm trying to identify the one that returns "TRUE" and place that value (Numeric) into a specific cell. Any help is greatly appreciated. Thanks! Alan

[Richard Buttrey]

Hi and welcome to the forum.

This is somewhat confusing.
If the cell contains the value "TRUE" where is the numeric value you're looking for?

Can I suggest you upload the workbook and manually add the result you expect to see and clearly idenify which is the result cell(s)

[kersplash]

If you can post an attachment that would help.

[Glenn Kennedy]

Will you please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).

1. Make sure that your sample data are truly REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired solution is also shown (mock up the results manually).

3. Make sure that all confidential information is removed first!!

4. Try to avoid using merged cells. They cause lots of problems!

Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

[alanos206]

=IF(A21="Non-FBC Equivalent",IF(B21="8d@6/6",IF(C21="Clips",IF(D21="A",IF(E21="C",IF(F21="Hip",IF(G21="No SWR",-0.76)))))))

[alanos206]

Here is a sample formula. "=IF(A21="Non-FBC Equivalent",IF(B21="8d@6/6",IF(C21="Clips",IF(D21="A",IF(E21="C",IF(F21="Hip",IF(G21="No SWR",-0.76)))))))"

[Sam Capricci]

Could you define what you mean by finding the "true" result? it seems simply that putting a filter at the header row and filtering out all the false values just leaving the non-false values (-0.76 in this case) would give you what you want. if there is more to it that might be why people are asking for an attached sheet with examples of the data.

[AlKey]

Perhaps this

Please Login or Register  to view this content.