One cell two formulas

December 2016


One cell two formulas




Issue


I have a cell that can change from "USD" to "PESO". When this cell is changed i need another cell to calculate appropriately. I have these two formulas that work but they are in two different cells. How can I combine these two seperate formulas to give the appropriate outcome?
1. "=IF(F6="USD",SUM(N6,O6,P6,,Q6,M6), "")" 
2. "=IF(F6="PESO",SUM(M6,N6,O6,,P6,Q6)/13,"")"

Solution


I figured it out. Here is the answer;
=IF(I18="USD",SUM(P18:T18),SUM(P18:T18)/13)

Note


Solved by fanderduck

Related :

This document entitled « One cell two formulas » from CCM (ccm.net) is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.