February 2017

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;

=IF(I18="USD",SUM(P18:T18),SUM(P18:T18)/13)

Solved by fanderduck

- One cell two formulas
- How to combine 2 formulas in excel
- Two formulas in same cell
- One cell two formulas (Solved)
- Excel - Formula based on the color of cell
- Automatically transfer data from one sheet to another (Solved)
- Insert picture in excel macro which takes the file name refrence [Solved]
- Comebiine multiple cells displays formula