setting column value based on if statement

[Brian Shafer]

hello,
Here is an example i've yet to figure out. in my cell I am looking at
if cell A16= "", if it is true then D16 ="", if it is false then
If(AND(B16=1, C16=1), A16*8, A16*12)
So, my statement would look like the following:
=IF(A16="","",IF(AND(B16="1",C16=1),A16*8,A16*12))
But what i can't figure out is how to set to set the value of a different
cell. For example...
With the above statement where B16 =1 and C16=1 the value of D16 would be
A16*8. When that condition is true I want to be able to set the value of
D15 to A16*4...
Any Idea on how to do that?
Brian

 

[Glen Mettler]

Mybe I'm missing something, but it seems to me that in D16 you should have:
=if(and(B16=1,C16=1),A16*4,0)

Glen

 

[Dave Peterson]

Worksheet formulas can only return a value to the cell that contains the
formula.

You can't change other cells.

But there are alternatives. You could use a little macro that updates other
cells--but you'd have to post some additional information--when should it be run
(on demand--by clicking a button?, whenever the user changes a value in a
certain cell(s), or when the worksheet recalculates (based on formulas
changing))