One cell two formulas

March 2017


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


Published by aakai1056.
This document, titled "One cell two formulas," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).