If function with more than 7 conditions
Need more info. It's not clear what you want.
In your sample it looks like cell A1 = 1 and.....
If Column A = 1, XS
OK. So, what do you want to do with that?
Biff
"joie" wrote in message
...
Hi!
Hope you can help me make if function that can compute for 13 conditions.
The data I'm working on is as follows:
A B C D E F G H I J K L M
1 1
2 1
3 1
4 1
5 1
6 1
I need a summary which says:
If Column A = 1, XS
If Column B = 1, S
If Column C = 1, M
If Column D = 1, L
If Column E = 1, XL
and so on...
A website I checked suggest VBA functions, but I really don't know how to
work with them.
Hope you can help me out.
Super thanks! :)
|