5 (10) Pinterest Inbox - pppprehan. LIOCODUE Lheny a.. dubizzle Dubai |Se. (1) IF Formula In G. Historical Results H. Forecast Period 2 FINANCIAL STATEMENTS 3 Balance Sheet Check 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 OK OK OK OK OK OK OK OK 4. 176 Assumption 177 Revenue Growth +-5% 178 COGS +15% 179 Discount Rate +/-5% 180 EVEBITDA +-5% 5% A +5% A Rank ABS Output Driver Pos Neg 181 The formula contained in the YELLOW cell (G179) is Hint: do not forget the $ when using absolute references. Use absolute reference so this formula can be copied over to other cells in this section without any manual modification. =SMALL(E177:E180,$F$179) =SMALL(F177:F180,$E$179) =SMALL($F$177:$F$180,E179) =SMALL($E$177:$E$180,F179) = here to search