Joining Two formulas with the Help of AND / OR / IF Functions to getthe desired result

A

Akash Maheshwari

Hi,

This is Akash Maheshwari. I am stuck with a formula and not able to
break through since last few days: I require your help in this
relates...

I have two Formulas:
=IF(D7="V Top 9702045619",AccountWiseReport!K5-F7+I7-J7+K7-G7-H7)
=IF(D7="V Top 9702043906",AccountWiseReport!K40-F7+I7-J7+K7-G7-H7)

What i want is if i select "V Top 9702045619" in the cell D7 the first
formula would run and viceversa if i select "V Top 9702043906" the
second formula should run. I want to combine the above mentioned two
formulas in such a way that i get the output in one cell.

How to combine the above mentioned two formulas with OR & AND function
with the help of IF function.

Many Thanks in Advance

Akash Maheshwari
 
J

Jim Thomlinson

Something like this will do since you only have 2 choices.

=IF(D7="V Top 9702045619",AccountWiseReport!K5, AccountWiseReport!K40)
-F7+I7-J7+K7-G7-H7
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combination to Two formulas with the Help of AND / OR / IF Functions 1
If condition to find Target 2
Shortening or changing a formula 7
How do I display 0 if it is the end result for a formula 4
Multiply Corresponding Values in Range 3
A staying on schedule formula: 2
Combination of IF, AND, and COUNTIF; need help 6
Combining formulas, "and" & "or" to verify content of multiple cel 15

Top