Try
In E1
=CHOOSE(COUNTIF(A1:D1,"0"),"Single","Double","Tri ple","Homerun")

If this post helps click Yes
---------------
Jacob Skaria


"frykid50" wrote:

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