if85%=5, 95%=2, 80%=?
PCosta87 Well-Known Member Feb 17, 2017 #2 Hi, Welcome to the forum ... That would be a simple nested IF formula. If you intend to have more options, like 70%, 65%, 50%, and so on, it will be better to use a helper table and do a VLOOKUP to return the values. Please refer to attachment. Attachments IF.xlsx 9.2 KB · Views: 6
Hi, Welcome to the forum ... That would be a simple nested IF formula. If you intend to have more options, like 70%, 65%, 50%, and so on, it will be better to use a helper table and do a VLOOKUP to return the values. Please refer to attachment.
PCosta87 Well-Known Member Feb 17, 2017 #4 bobhc said: 7.5% Click to expand... Ohh... I see If it is a logic sequence where -10% = +3 (95%->85%... 2->5) then -5% should be +1.5 Wouldn't the result be 6.5? Formula in attachment Attachments Chandoo.xlsx 8.1 KB · Views: 7
bobhc said: 7.5% Click to expand... Ohh... I see If it is a logic sequence where -10% = +3 (95%->85%... 2->5) then -5% should be +1.5 Wouldn't the result be 6.5? Formula in attachment
B bosco_yip Excel Ninja Feb 17, 2017 #5 Or, use Forecast function, In B3 : =FORECAST(A3,B1:B2,A1:A2) Regards Bosco Last edited: Feb 17, 2017