One cell two formulas

October 2016

One cell two formulas


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,"")"


I figured it out. Here is the answer;


Solved by fanderduck

Related :

This document entitled « One cell two formulas » from CCM ( 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.