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