Assistance

%3CLINGO-SUB%20id%3D%22lingo-sub-2900508%22%20slang%3D%22en-US%22%3EAssistance%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2900508%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20took%20over%20another%20persons%20excel%20sheet.%26nbsp%3B%20We%20added%20another%20factor%20in%20the%20formula%20and%20need%20to%20modify%20this%20formula%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%3DIF(AB4%26lt%3B%26gt%3B%22N%22%2C%20IF(I4%3D%22Y%22%2C150%2C%20(%3CBR%20%2F%3E(HLOOKUP(J4%2CBI_FACTORS%2C2%2CFALSE)*BIF1_Weight)%20%2B%3CBR%20%2F%3E(HLOOKUP(K4%2CBI_FACTORS%2C3%2CFALSE)*BIF2_Weight)%20%2B%3CBR%20%2F%3E(HLOOKUP(L4%2CBI_FACTORS%2C4%2CFALSE)*BIF3_Weight)%20%2B%3CBR%20%2F%3E(HLOOKUP(M4%2CBI_FACTORS%2C5%2CFALSE)*BIF4_Weight)%20%2B%3CBR%20%2F%3E(HLOOKUP(N4%2CBI_FACTORS%2C6%2CFALSE)*BIF5_Weight)%20%2B%3CBR%20%2F%3E(HLOOKUP(P4%2CUrgencyWeights%2C2%2CFALSE))%20%2B%3CBR%20%2F%3E(HLOOKUP(S4%2CTechnicalRiskWeights%2C2%2CFALSE)))%20%2F%3CBR%20%2F%3E(HLOOKUP(Q4%2CLevelOfEffortWeights%2C2%2CFALSE)))%2C0)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethe%20formula%20divides%20all%20the%20above%20by%20a%20single%20dollar%20amount%2C%20I%20need%20to%20and%20another%20dollar%20amount%2C%20before%20we%20divide.%26nbsp%3B%20The%20column%20is%20R4%2CNonSWLOE.%26nbsp%3B%20the%20name%20value%20is%20NonSWLOE.%26nbsp%3B%20Any%20help%20would%20be%20appreciated%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2900508%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hi, I took over another persons excel sheet.  We added another factor in the formula and need to modify this formula: 

=IF(AB4<>"N", IF(I4="Y",150, (
(HLOOKUP(J4,BI_FACTORS,2,FALSE)*BIF1_Weight) +
(HLOOKUP(K4,BI_FACTORS,3,FALSE)*BIF2_Weight) +
(HLOOKUP(L4,BI_FACTORS,4,FALSE)*BIF3_Weight) +
(HLOOKUP(M4,BI_FACTORS,5,FALSE)*BIF4_Weight) +
(HLOOKUP(N4,BI_FACTORS,6,FALSE)*BIF5_Weight) +
(HLOOKUP(P4,UrgencyWeights,2,FALSE)) +
(HLOOKUP(S4,TechnicalRiskWeights,2,FALSE))) /
(HLOOKUP(Q4,LevelOfEffortWeights,2,FALSE))),0)

 

the formula divides all the above by a single dollar amount, I need to and another dollar amount, before we divide.  I need to add two dollar amounts together before we divide the second dollar amount would be the column is R4,NonSWLOE.  the name value is NonSWLOE.  Any help would be appreciated

 

1 Reply

@WKT_BWR 

 

Unless there's highly confidential information in the spreadsheet itself, could you please post a copy of it in addition to the formula with which you want help. There are a lot of conditions referred to...making it hard to recreate what you're working with.

 

If there's confidential info, perhaps you could help us help you by posting a mockup without that confidential info, but otherwise representing the reality.