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), "")"
I figured it out. Here is the answer;
Solved by fanderduck
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