Prev: Search multiple columns
Next: Combination to Two formulas with the Help of AND / OR / IF Functio
From: Akash on 27 Apr 2010 01:44
Hi,

This is Akash Maheshwari, a frequent user of your group. I had querry
which i m not able to break through since last few days:

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.

 | 
Pages: 1
Prev: Search multiple columns
Next: Combination to Two formulas with the Help of AND / OR / IF Functio