A few words of thanks would be greatly appreciated.

One cell two formulas

Latest update on August 16, 2010 at 05:36 AM by aakai1056 .

One cell two formulas

Issue
Solution
Note

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

How to put two formulas in one cell
Two formulas in one cell - Best answers
Two formula in one cell - Best answers
The result of a formula in a cell is the - Forum - Excel
How many if formulas in one cell - How-To - Excel
Formula to copy cells from one sheet to another - How-To - Excel
Formula: to count cells and then add number. ✓ - Forum - Excel
Formula help - if cell contains a number, +1. ✓ - Forum - 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).

Excel - Copy rows until a given line

Find and replace cell value macro

One cell two formulas

Issue

Solution

Note

Subscribe To Our Newsletter!