| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Joining Two formulas with the Help of AND / OR / IF Functions to getthe desired result
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Joining Two formulas with the Help of AND / OR / IF Functions to g
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 -- HTH... Jim Thomlinson "Akash Maheshwari" wrote: 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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Which functions and Procedure to use to have desired result? | Excel Worksheet Functions | |||
| Formula to return desired Result | Excel Discussion (Misc queries) | |||
| how to drop leading zero in 0.700? desired result is .700 | Excel Discussion (Misc queries) | |||
| Which numbers give desired result | Excel Discussion (Misc queries) | |||
| which function can get the desired result? | Excel Worksheet Functions | |||
Linear Mode
