New formula with IF statements

[jpatierno]

A formula in cell E11 that would say E11 = H11+ (ALLDATA!BC6*2)
IF ALLDATA! T6/220<5.5, THEN ALLDATA!BC6 =0
IF ALLDATA!T6/220>11.5, THEN BC6=BE6
IF ALLDATA!T6/220<5.5 THEN H11=H12

 

[Scott Huish]

You can't change another cells value with a formula.

 

[jpatierno]

E11 is empty. I want to put this H11+ (ALLDATA!BC6*2) in there with the IF statements

 

[jpatierno]

ACTUALLY i JUST PUT THAT FORMULA IN E11 AND IT WORKS. NOW I NEED TO PUT THE REST OF THE IF STATEMENTS WHICH i DON'T KNOW

 

[Scott Huish]

formula in cell E11 that would say E11 = H11+ (ALLDATA!BC6*2)
IF ALLDATA! T6/220<5.5, THEN ALLDATA!BC6 =0
IF ALLDATA!T6/220>11.5, THEN BC6=BE6
IF ALLDATA!T6/220<5.5 THEN H11=H12

Your description is altering 4 different cells (after THEN). E11, BC6 on ALLDATA, BC6 not on ALLDATA and H11. You can't change other cells values with a formula in a different cell.

 

[jpatierno]

ok sorry for the confusion. brand new to this and probably in over my head. so I have 2 sheets. ALLDATA with all the data and a 2nd sheet with no data at all called figs. on the figs sheet in H11 there is a value from ALLDATA. I want to take that value and add it to ALLDATA!BC6 *2 and place the results in E11 which is empty. Then I want to say if the value in ALLDATA!T6/220 >11.5 then I want to use the value in ALLDATA!BE6 in place of BC6. and then if IF ALLDATA!T6/220<5.5 THEN H11=I11. I miss printed before it's H11 to I11. also forget about the line setting BC6=0