Perfect... Thanks very much. I was struggling with the "or" formula. I
thought I was missing something simple.

"K.S.Warrier" wrote:

hi,
try this.
for F1, put =if(and(a1b1,a1c1,a1d1),"max all","")
and for G1, put =if(or(a1b1,a1c1,a1d1),"max one or more","")
K.S.Warrier

"Shooter" wrote:

I have values in cells A1:D1. In cell F1, I would like a formula that will
print the words "Max all" if A1B1 and A1C1 and A1D1.
I would also like a formula in cell G1 that will print the words "Max one or
more" if A1B1 or A1C1 or A1D1.
I do not want to use the "max" command in either of the above formulas.
Thanks for the help.


--
Shooter