One cell two formulas

Solved/Closed
Report
Posts
2
Registration date
Thursday August 12, 2010
Status
Member
Last seen
August 15, 2010
-
Posts
6428
Registration date
Sunday June 6, 2010
Status
Moderator
Last seen
July 16, 2020
-
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,"")"

Your help will be greatly appreciated.

1 reply

Posts
2
Registration date
Thursday August 12, 2010
Status
Member
Last seen
August 15, 2010

I figured it out. Here is the answer.

=IF(I18="USD",SUM(P18:T18),SUM(P18:T18)/13)
0
Posts
6428
Registration date
Sunday June 6, 2010
Status
Moderator
Last seen
July 16, 2020

Hello,
Thanks for coming back to post the answer.
0