Shorten Formula?

J

Joe Gieder

Can this formula be shortened to eliminate some of the
IFs? It's up to 5 and I kmow 7 is the limit.

Array entered

IF(ISTEXT(R293),"",IF($H293="Yes",(VLOOKUP(K293,'MSP
Listing'!$A$4:$C$1776,3,0)),(IF(ISNA(INDEX(UnitCost,MATCH
($K293&MIN(IF((PN=$K293)*(ExtendCost<>0)*
(Quoted<>"Yes"),ExtendCost)),PN&ExtendCost,),0)),0,INDEX
(UnitCost,MATCH($K293&MIN(IF((PN=$K293)*(ExtendCost<>0)*
(Quoted<>"Yes"),ExtendCost)),PN&ExtendCost,),0)))))

TIA
Joe
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula Returning "FALSE" 2
Formula Partially Works, Please Help 0
Using INDEX & AND 0
Using INDEX twice?? 3
Help to shorten a formula 5
Repost - Functions on filtered data 0
Imposs? Speed up 1
Conditional Formatting on Index,Match formula 3

Top