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
Spreadsheet formulas - Guide
If cell contains date then return value ✓ - Office Software Forum
An example of a cell is a blank cell ✓ - Programming Forum
Ms excel marksheet formulas pdf - Guide

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

Formula to subtract one cell value from another.

help me to add particular cells

Highlight cell if another cell contains specific text

If a cell contains any text then add a value

Counting cells containing only numbers

Similar discussions

Subscribe To Our Newsletter!