Prev: Combination to Two formulas with the Help of AND / OR / IF Functions
Next: is it possible to run code written inside a cell
From: Jacob Skaria on 27 Apr 2010 02:29
Copy paste the below and apply to the cell....

=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,""))

--
Jacob (MVP - Excel)


"Akash" wrote:

> 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: Combination to Two formulas with the Help of AND / OR / IF Functions
Next: is it possible to run code written inside a cell