Logic Statement

[abierly]

Hello. I'm trying to have one cell look at two other cells to determine
its entry.

This what I'm stuck on:

=If(E4=1 and E7=1, 60, if(E4=1 and E7=2, 50, if(E4=1 and E7=3, 40,
if(E4=2 and E7=1, 30, if(E4=2 and E7=2, 20, if(E4=2 and E7=3, 10,
if(E4=3 and E7=1, 15, if(E4=3 and E7=2, 10, if(E4=3 and E7=3, 5,
0)))))))))

Can anyone please help me?

 

[Chip Pearson]

Try

=IF(AND(E4=1,E7=1),60,IF(AND(F4=1,E7=2,50).....


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"abierly" <[email protected]>
wrote in message
news:[email protected]...

 

[Guest]

Hi

Here's something a bit different!! Try this:
=VLOOKUP(E4+(E7/10),{1.1,60;1.2,50;1.3,40;2.1,30;2.2,20;2.3,10;3.1,15;3.2,10;3.3,5},2,FALSE)

Andy.

 

[Ron Rosenfeld]

Hello. I'm trying to have one cell look at two other cells to determine
its entry.

This what I'm stuck on:

=If(E4=1 and E7=1, 60, if(E4=1 and E7=2, 50, if(E4=1 and E7=3, 40,
if(E4=2 and E7=1, 30, if(E4=2 and E7=2, 20, if(E4=2 and E7=3, 10,
if(E4=3 and E7=1, 15, if(E4=3 and E7=2, 10, if(E4=3 and E7=3, 5,
0)))))))))

Can anyone please help me?

Here's one approach:

=IF(AND(E7>=1,E7<=3),
IF(E4=1,CHOOSE(E7,60,50,40),
IF(E4=2,CHOOSE(E7,30,20,10),
IF(E4=3,CHOOSE(E7,15,10,5)))),0)


--ron