One cell two formulas

Solved/Closed

fanderduck Posts 2 Registration date Thursday August 12, 2010 Status Member Last seen August 15, 2010 - Aug 13, 2010 at 10:07 AM
jack4rall Posts 6428 Registration date Sunday June 6, 2010 Status Moderator Last seen July 16, 2020 - Aug 15, 2010 at 04:56 PM

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.

One cell two formulas
Little alchemy formulas - Guide
If cell contains text then return value multiple conditions ✓ - Excel Forum
If cell contains date then return value ✓ - Office Software Forum
Conditional formatting if cell contains text - Excel Forum
Excel formula =if two cells match then return value in another cell ✓ - Excel Forum

1 response

Answer 1 / 1

fanderduck Posts 2 Registration date Thursday August 12, 2010 Status Member Last seen August 15, 2010
Aug 15, 2010 at 04:41 PM

I figured it out. Here is the answer.

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

jack4rall Posts 6428 Registration date Sunday June 6, 2010 Status Moderator Last seen July 16, 2020
Aug 15, 2010 at 04:56 PM

Hello,
Thanks for coming back to post the answer.

Similar discussions

Counting cells containing only numbers

Formula to subtract one cell value from another.

If a cell contains any text then add a value

help me to add particular cells

How to use conditional format based on text?

Similar discussions

Subscribe To Our Newsletter!