| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using multiple IF criteria
I've done this before but can't remember how I did it. I want to do an IF
type formula (I think) that refers to a value in another cell based on the value in two cells. For example, B1 equals "A" and B2 equals 5%. If those two criteria match the query, then I want the value to be what is in B3. Any suggestions? Thanks -- JerryS |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using multiple IF criteria
=if(and(b1="A",b2=.05),B3,"")
Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "JerryS" wrote: I've done this before but can't remember how I did it. I want to do an IF type formula (I think) that refers to a value in another cell based on the value in two cells. For example, B1 equals "A" and B2 equals 5%. If those two criteria match the query, then I want the value to be what is in B3. Any suggestions? Thanks -- JerryS |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Using multiple IF criteria
=(B1="A")*(B2=5%)*B3
or =IF(And(B1="A",B2=5%),B3;"") Hans "JerryS" skrev i en meddelelse ... I've done this before but can't remember how I did it. I want to do an IF type formula (I think) that refers to a value in another cell based on the value in two cells. For example, B1 equals "A" and B2 equals 5%. If those two criteria match the query, then I want the value to be what is in B3. Any suggestions? Thanks -- JerryS |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple results in 1 cell w/ multiple criteria | Excel Worksheet Functions | |||
| Multiple Sheet, Multiple Criteria Look-Up Function Help | Excel Worksheet Functions | |||
| return multiple records matching multiple criteria | Excel Worksheet Functions | |||
| Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
| Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
Linear Mode
