| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculate formula of another cell
I need for one cell to use the formula inputted on another cell under a
certain condition. Here is the 1st formula: =IF(AND($C$6=75%),'Dept acc'!H69,IF(AND($C$6=50%),'Dept acc'!H65,IF(AND($C$6=25%),'Dept acc'!H61,'Dept acc'!H73))) In the dept acc H69 cell is the following formula: =IF(AND(B69<=1802.25),1,IF(AND(B69=1802.26,B69<=3 602.25),2, IF(AND(B69=3602.26,B69<=5402.25),3, IF(AND(B69=5402.26,B69<=7202.25),4, IF(AND(B69=7202.26),5))))) I need for the computer to calculate the formula in H69 cell when that $C$6 is 75% and another formula when $C$6 is 50% etc.. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need Formula to calculate n*'cell value' where n is any integer | Excel Discussion (Misc queries) | |||
| Can you calculate a formula in the same cell where you enter the d | Excel Discussion (Misc queries) | |||
| formula won't calculate unless I click cell | Excel Worksheet Functions | |||
| On excel, my formula will not calculate and add info into cell | Excel Worksheet Functions | |||
| X IN A CELL TO CALCULATE A FORMULA | Excel Worksheet Functions | |||
Threaded Mode
