| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for < and results
a b
1 Sue 8 2 Ann 5 3 Sue 4 I would like a formula if A=Sue and B is =4 but =<6 the result is 1. THANK YOU!!!! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula for < and results
You didn't say what you wanted if the formula evaluated as false so this one
returns Unspecified. =IF(AND(A1="Sue",AND(B1=4,B1<=6)),1,"Unspecified" ) Mike "TMF in MN" wrote: a b 1 Sue 8 2 Ann 5 3 Sue 4 I would like a formula if A=Sue and B is =4 but =<6 the result is 1. THANK YOU!!!! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula for < and results
7ou're right, I did not clarify. I would like the formula to read column A
and column B so that the formula will count how many times Sue's numbers are between 4 and 6, how many times Ann's numbers are between 4 and 6.... then between 7 and 10.... 11 and 15... etc. THANK YOU!!! "Mike H" wrote: You didn't say what you wanted if the formula evaluated as false so this one returns Unspecified. =IF(AND(A1="Sue",AND(B1=4,B1<=6)),1,"Unspecified" ) Mike "TMF in MN" wrote: a b 1 Sue 8 2 Ann 5 3 Sue 4 I would like a formula if A=Sue and B is =4 but =<6 the result is 1. THANK YOU!!!! |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula for < and results
=SUMPRODUCT(--(A1:A3="Sue"),--(B1:B3=4),--(B1:B3<=6))
or =SUMPRODUCT((A1:A3="Sue")*(B1:B3=4)*(B1:B3<=6)) -- David Biddulph "TMF in MN" wrote in message ... 7ou're right, I did not clarify. I would like the formula to read column A and column B so that the formula will count how many times Sue's numbers are between 4 and 6, how many times Ann's numbers are between 4 and 6.... then between 7 and 10.... 11 and 15... etc. THANK YOU!!! "Mike H" wrote: You didn't say what you wanted if the formula evaluated as false so this one returns Unspecified. =IF(AND(A1="Sue",AND(B1=4,B1<=6)),1,"Unspecified" ) Mike "TMF in MN" wrote: a b 1 Sue 8 2 Ann 5 3 Sue 4 I would like a formula if A=Sue and B is =4 but =<6 the result is 1. THANK YOU!!!! |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula for < and results
And of course you don't need the extra AND().
=IF(AND(A1="Sue",B1=4,B1<=6),1,"Unspecified") -- David Biddulph "Mike H" wrote in message ... You didn't say what you wanted if the formula evaluated as false so this one returns Unspecified. =IF(AND(A1="Sue",AND(B1=4,B1<=6)),1,"Unspecified" ) Mike "TMF in MN" wrote: a b 1 Sue 8 2 Ann 5 3 Sue 4 I would like a formula if A=Sue and B is =4 but =<6 the result is 1. THANK YOU!!!! |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula for < and results
I tried this but of course it didn't work!!!
countIF(AND(A1:A5="sue",AND(b1:b5=4,B1:B5<=6)),1) "David Biddulph" wrote: And of course you don't need the extra AND(). =IF(AND(A1="Sue",B1=4,B1<=6),1,"Unspecified") -- David Biddulph "Mike H" wrote in message ... You didn't say what you wanted if the formula evaluated as false so this one returns Unspecified. =IF(AND(A1="Sue",AND(B1=4,B1<=6)),1,"Unspecified" ) Mike "TMF in MN" wrote: a b 1 Sue 8 2 Ann 5 3 Sue 4 I would like a formula if A=Sue and B is =4 but =<6 the result is 1. THANK YOU!!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can you wrap formula results via a formula eg. Alt Enter | Excel Discussion (Misc queries) | |||
| How do I view formula results intead of formula in excel? | Excel Worksheet Functions | |||
| View formula results instead of formula in 2003 version? | Excel Discussion (Misc queries) | |||
| Modifying a formula to display the results of another formula | Excel Worksheet Functions | |||
| I want the results of a formula to show in cell, NOT THE FORMULA! | Excel Discussion (Misc queries) | |||
Hybrid Mode
