if senerios with 2 factors

T

Tacklemom

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

v look value dependant on 2 cells 2
formula for if and v look up for 2 values 3
Looking to added up based on a character from cell range 1
Cumulative formula for word table 0
formula for multiple variables. 2
Development combinations with exclusion of columns 0
Slideshow with black border around it 0
Automatically sending multiple parts of text from one word doc to another - is possible. 0

Top