=LOOKUP(COUNTIF(a5:d5,"0"),{0,1,2,3},{"","s","d", "t"})
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"frykid50" wrote in message
...
Okay, this is a strange one to me. I have 4 columns of sales numbers that
I'm looking at. If only 1 of these columns has sales (value greater than
zero) then I want to return "Single" in a 5th column. If 2 of the 4
columns
show sales, I want "double"; 3 of 4 is "triple", and 4 of 4 is a
"homerun".

Since an if statement will only allow me to nest 3, any suggestions on a
formula to use?

Sample data
A B C D E
100 50 0 0
0 400 50 10