Subsets

J

jr

Some programming languages (PASCAL for one) have
functions that allow sets to be defined.
for example:
FRUIT(apple, banana, orange, peach, guava, mango,
pineapple)
and use as:
A B Result of B
1 peach IF(A1=fruit,"yum","yuck") yum
2 orange IF(A1=fruit,"yum","yuck") yum
3 cheese IF(A1=fruit,"yum","yuck") yuck

Very powerful for eliminating "IF" conditions.
Any such function in EXCEL?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Search cell value in same column 3
Array reference 3
How to determine the number of types? 5
Copy & Paste Non Blanks Only 2
What would be the most effective way to do this? 5
sorting fields in a record 3
counif by column2 & column 4 ? 3
How to determine the value? 5

Top