Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can anyone see a problem with this?
I've currently got 2 sheets and i'm comparing 2 cells in one worksheet to 2 cells in another, if they match then the output is the 3rd cell, or another if statement if false. The if statements work if i terminate the fomula on number 9, if i add 10 the formula fails, if i do all the clicking on cells to let excel add the rest of the formula for 10 it also fails. I've put each nested if/and on a separate line for ease of reading, the double space between 9 and 10 signifies the point where it stops working. Any help/info is much appreciated as its driving me batty. Thanks =IF(AND(Blank!B18=Miles!$B$3,Blank!C18=Miles!$C$3) ,Miles!$D$3, IF(AND(Blank!B18=Miles!$B$4,Blank!C18=Miles!$C$4), Miles!$D$4, IF(AND(Blank!B18=Miles!$B$5,Blank!C18=Miles!$C$5), Miles!$D$5, IF(AND(Blank!B18=Miles!$B$6,Blank!C18=Miles!$C$6), Miles!$D$6, IF(AND(Blank!B18=Miles!$B$7,Blank!C18=Miles!$C$7), Miles!$D$7, IF(AND(Blank!B18=Miles!$B$8,Blank!C18=Miles!$C$8), Miles!$D$8, IF(AND(Blank!B18=Miles!$B$9,Blank!C18=Miles!$C$9), Miles!$D$9, IF(AND(Blank!B18=Miles!$B$10,Blank!C18=Miles!$C$10 ),Miles!$D$10, IF(AND(Blank!B18=Miles!$B$11,Blank!C18=Miles!$C$11 ),Miles!$D$11, IF(AND(Blank!B18=Miles!$B$12,Blank!C18=Miles!$C$12 ),Miles!$D$12, IF(AND(Blank!B18=Miles!$B$13,Blank!C18=Miles!$C$13 ),Miles!$D$13, IF(AND(Blank!B18=Miles!$B$14,Blank!C18=Miles!$C$14 ),Miles!$D$14, IF(AND(Blank!B18=Miles!$B$15,Blank!C18=Miles!$C$15 ),Miles!$D$15, IF(AND(Blank!B18=Miles!$B$16,Blank!C18=Miles!$C$16 ),Miles!$D$16,0)))))))))))))) -- bikky ------------------------------------------------------------------------ bikky's Profile: http://www.excelforum.com/member.php...o&userid=36149 View this thread: http://www.excelforum.com/showthread...hreadid=559359 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
have some problem with database | Excel Discussion (Misc queries) | |||
Urgent Help Required on Excel Macro Problem | Excel Discussion (Misc queries) | |||
Problem With Reference Update | Excel Worksheet Functions | |||
Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) |