If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Using 'AND' logic in a SUMIF statement | IpcTrain | Worksheet Functions | 2 | March 10th, 2006 05:39 PM |
Two Logic tests in an IF Statement | timmadge | Worksheet Functions | 2 | February 7th, 2006 03:15 PM |
Calculated Mean | Charles Deng | Running & Setting Up Queries | 21 | October 15th, 2004 08:37 PM |
Access 2000 query SQL statement into VBA code | Clint | Running & Setting Up Queries | 1 | June 10th, 2004 01:33 PM |
If Statement Logic Not Working | rbyrns | Worksheet Functions | 2 | December 23rd, 2003 01:41 PM |