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