Previous Topic Next Topic

One cell two formulas

Solved/Closed
fanderduck Posts 2 Registration date Thursday 12 August 2010 Status Member Last seen 15 August 2010 - 13 Aug 2010 à 10:07
jack4rall Posts 6428 Registration date Sunday 6 June 2010 Status Moderator Last seen 16 July 2020 - 15 Aug 2010 à 16:56
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 response

Réponse 1 / 1
fanderduck Posts 2 Registration date Thursday 12 August 2010 Status Member Last seen 15 August 2010
15 Aug 2010 à 16:41
I figured it out. Here is the answer.

=IF(I18="USD",SUM(P18:T18),SUM(P18:T18)/13)
jack4rall Posts 6428 Registration date Sunday 6 June 2010 Status Moderator Last seen 16 July 2020
15 Aug 2010 à 16:56
Hello,
Thanks for coming back to post the answer.

Similar discussions

Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
If a cell contains any text then add a value
cbrizz -
Pharmanumbers -

20 responses
Phone lock code for gt-e1200y
migs23 -
Computertech -

1 response
How to activate the Button as Activecell
adikademani -
ac3mark -

1 response