differentiating between "and"/"or" in a formula

[Shooter]

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

 

[Frank Kabel]

Hi
have a look at the LARGE function

 

[Shooter]

The "large" function will be helpfull but I was really just trying to
determine the difference in a basic formula between "and" and "or" scenarios.
I am a bit of a novice and would really appreciate if you could write a
simple formula for the enclosed scenario. Thanks again.

 

[Frank Kabel]

Hi
just wondering why you do not want to use the MAX function (homework??)
But try:
IF(COUNTIF(B11,"<" & A1)=3,"MAX",IF(COUNTIF(B11,"<" & A1)>0,"MAX
one or more","smallest"))

 

[K.S.Warrier]

hi,
try this.
for F1, put =if(and(a1>b1,a1>c1,a1>d1),"max all","")
and for G1, put =if(or(a1>b1,a1>c1,a1>d1),"max one or more","")
K.S.Warrier

 

[Shooter]

Thanks Frank. I appreciate your assistance with this one.

 

[Shooter]

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