One cell two formulas
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
- How to put two formulas in one cell
- Two formulas in one cell - Best answers
- Two formula in one cell - Best answers
- Excel formula to copy cell value from another sheet ✓ - Forum - Excel
- Excel putting result of a formula in another cell - Forum - Excel
- Formula to copy cells from one sheet to another - How-To - Excel
- Excel formula based on cell color - How-To - Excel
- How many if formulas in one cell - How-To - Excel
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).
Subscribe To Our Newsletter!
