Menu
Thanks
0
Thanks

A few words of thanks would be greatly appreciated.

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
Thanks
0
Thanks

A few words of thanks would be greatly appreciated.

Ask a question
CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jeff Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.

Published by . Latest update on 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 (https://ccm.net/).

0 Comments