|
differentiating between "and"/"or" in a formula
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 |
Hi
have a look at the LARGE function -- Regards Frank Kabel Frankfurt, Germany "Shooter" schrieb im Newsbeitrag ... 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 |
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" wrote: Hi have a look at the LARGE function -- Regards Frank Kabel Frankfurt, Germany "Shooter" schrieb im Newsbeitrag ... 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 |
Hi
just wondering why you do not want to use the MAX function (homework??) But try: IF(COUNTIF(B1:D1,"<" & A1)=3,"MAX",IF(COUNTIF(B1:D1,"<" & A1)0,"MAX one or more","smallest")) -- Regards Frank Kabel Frankfurt, Germany "Shooter" schrieb im Newsbeitrag ... 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" wrote: Hi have a look at the LARGE function -- Regards Frank Kabel Frankfurt, Germany "Shooter" schrieb im Newsbeitrag ... 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 |
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 |
Thanks Frank. I appreciate your assistance with this one.
"Frank Kabel" wrote: Hi just wondering why you do not want to use the MAX function (homework??) But try: IF(COUNTIF(B1:D1,"<" & A1)=3,"MAX",IF(COUNTIF(B1:D1,"<" & A1)0,"MAX one or more","smallest")) -- Regards Frank Kabel Frankfurt, Germany "Shooter" schrieb im Newsbeitrag ... 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" wrote: Hi have a look at the LARGE function -- Regards Frank Kabel Frankfurt, Germany "Shooter" schrieb im Newsbeitrag ... 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 |
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 |
| All times are GMT +1. The time now is 05:19 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com