| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combination to Two formulas with the Help of AND / OR / IF Functions
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| combination INDEX//MATCH and IF-functions | Excel Discussion (Misc queries) | |||
| Combination of formulas, if, and, or | Excel Worksheet Functions | |||
| combination functions in one cell | Excel Worksheet Functions | |||
| combination of functions? | Excel Worksheet Functions | |||
| Combination of functions for a conditional format and an array | Excel Worksheet Functions | |||
Threaded Mode
