| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
create a formula that determines if yes between say C7-C13...
I have a formula that multiplies two different cells:
=PRODUCT(B30:B31) I have another column that determines eligibility (i.e. a yes or no indicated in each cell). What I want to do is create a formula that determines if yes between say C7-C13, then multiply the two different cells as described above, otherwise if blank or no, then do not multiply the two cells. Any help would be greatly appreciated! Thanks in advance! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
create a formula that determines if yes between say C7-C13...
You could try something like this
=PRODUCT(IF(C2:C7="YES",B2:B7)) activate with CTRL SHIFT ENTER "Jennifer" wrote: I have a formula that multiplies two different cells: =PRODUCT(B30:B31) I have another column that determines eligibility (i.e. a yes or no indicated in each cell). What I want to do is create a formula that determines if yes between say C7-C13, then multiply the two different cells as described above, otherwise if blank or no, then do not multiply the two cells. Any help would be greatly appreciated! Thanks in advance! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
create a formula that determines if yes between say C7-C13...
try:
=IF(COUNTIF(C7:C13,"yes"), B30*B31, "") "Jennifer" wrote: I have a formula that multiplies two different cells: =PRODUCT(B30:B31) I have another column that determines eligibility (i.e. a yes or no indicated in each cell). What I want to do is create a formula that determines if yes between say C7-C13, then multiply the two different cells as described above, otherwise if blank or no, then do not multiply the two cells. Any help would be greatly appreciated! Thanks in advance! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
create a formula that determines if yes between say C7-C13...
You could try something like this
=PRODUCT(IF(C2:C7="YES",B2:B7)) activate with CTRL SHIFT ENTER "Jennifer" wrote: I have a formula that multiplies two different cells: =PRODUCT(B30:B31) I have another column that determines eligibility (i.e. a yes or no indicated in each cell). What I want to do is create a formula that determines if yes between say C7-C13, then multiply the two different cells as described above, otherwise if blank or no, then do not multiply the two cells. Any help would be greatly appreciated! Thanks in advance! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Variable Determines Number of Cell in Formula Range | Excel Worksheet Functions | |||
| Function that determines whether a number is between two numbers | Excel Worksheet Functions | |||
| Whether 3 diff fields are blank determines several different resul | Excel Worksheet Functions | |||
| How do I enter a time formula into a worksheet that determines if. | Excel Discussion (Misc queries) | |||
| Create a formula that determines a date-sensitive File-Name from w | Excel Worksheet Functions | |||
Linear Mode
