Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using 'AND' logic in a SUMIF statement | Excel Worksheet Functions | |||
Two Logic tests in an IF Statement | Excel Worksheet Functions | |||
Logic question | Excel Discussion (Misc queries) | |||
Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
Logic statement returns wrong answer. | Excel Worksheet Functions |