View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sweetpeach sweetpeach is offline
external usenet poster
 
Posts: 3
Default 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..