Oct 29 2021 07:41 AM - edited Oct 29 2021 08:43 AM
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
Oct 29 2021 02:41 PM
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.