Logic Statement
 

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?


--
abierly
------------------------------------------------------------------------
abierly's Profile: http://www.excelforum.com/member.php...o&userid=32452
View this thread: http://www.excelforum.com/showthread...hreadid=522255

Logic Statement
 

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"
wrote in message
...

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?


--
abierly
------------------------------------------------------------------------
abierly's Profile:
http://www.excelforum.com/member.php...o&userid=32452
View this thread:
http://www.excelforum.com/showthread...hreadid=522255

Logic Statement
 

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.

"Chip Pearson" wrote in message
...
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" wrote in
message ...

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?


--
abierly
------------------------------------------------------------------------
abierly's Profile:
http://www.excelforum.com/member.php...o&userid=32452
View this thread:
http://www.excelforum.com/showthread...hreadid=522255

Logic Statement
 

On Tue, 14 Mar 2006 10:43:31 -0600, abierly
wrote:


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