Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple critera
Hi, I need help with a formula for the following:
If Column E =7 and Column F = 7 and column G = F it can return a value of True if not False Thanks Donna |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple critera
hi
try this.... =IF(AND(E2=7,F2=7,G2="F"),TRUE,FALSE) Regards FSt1 "Donna" wrote: Hi, I need help with a formula for the following: If Column E =7 and Column F = 7 and column G = F it can return a value of True if not False Thanks Donna |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple critera
Donna wrote:
Hi, I need help with a formula for the following: If Column E =7 and Column F = 7 and column G = F it can return a value of True if not False Thanks Donna Here are a few options that demonstrate different ways to check multiple conditions... Straightforward, with clear intentions: =IF(AND(E2=7,F2=7,G2="F"),TRUE) Slightly more sophisticated, uses fewer functions: =IF((E2=7)*(F2=7)*(G2="F"),TRUE) Bending toward the absurd for this example: =SUMPRODUCT((E2=7)*(F2=7)*(G2="F"))=--TRUE |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple critera
Thank you very much Donna "FSt1" wrote: hi try this.... =IF(AND(E2=7,F2=7,G2="F"),TRUE,FALSE) Regards FSt1 "Donna" wrote: Hi, I need help with a formula for the following: If Column E =7 and Column F = 7 and column G = F it can return a value of True if not False Thanks Donna |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula with multiple critera | Excel Discussion (Misc queries) | |||
Sumproduct Lookup with multiple critera? | Excel Worksheet Functions | |||
Multiple critera with in a sumif statement | Excel Discussion (Misc queries) | |||
help with sumif formula with multiple critera | Excel Worksheet Functions | |||
SUMPRODUCT multiple critera from different worksheets | Excel Worksheet Functions |