| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if senerios with 2 factors
Wanting to know what to formulate V look up with to if factors
eg: if B2=304 and C3=1/2, then v look up = E4 The only problem is B2 can either be 1/2, 1/4, 3/16, or 1/8 and C3 can be either 304 or 316. I want to have to be positve ( true ) for both if's to calculate a v look up.... Help! -- Donna |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
if senerios with 2 factors
=IF(AND(B2=304,C3=.5),VLOOKUP(),"Do Nothing")
-- Wag more, bark less "Tacklemom" wrote: Wanting to know what to formulate V look up with to if factors eg: if B2=304 and C3=1/2, then v look up = E4 The only problem is B2 can either be 1/2, 1/4, 3/16, or 1/8 and C3 can be either 304 or 316. I want to have to be positve ( true ) for both if's to calculate a v look up.... Help! -- Donna |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ANOVA with two factors | Excel Worksheet Functions | |||
| Multiply one value by many factors | Excel Worksheet Functions | |||
| Can Excel reveal factors for success? | Excel Discussion (Misc queries) | |||
| Multiple IF factors | Excel Worksheet Functions | |||
| Excel - Discount Factors and NOV | Excel Worksheet Functions | |||
Linear Mode
