Conditionally Move Data?

[napalmmk9]

I have a worksheet on which I am trying to move data from one column to another based on a condition. Basically, I need to move moneys from an "encumbered" column to a "spent" column based on whether or not an item was recieved -- a binary condition, so I thought I could use a checkbox, although I don't know my VBA too well (hence asking here), and I'd need a check box in practically every row on the spreadsheet. I eventually tried an if function.

So "spent" is column a, "encumbered" is column b, and "is item recieved" is in column c.

So I tried =IF(c1="yes", a1=b1, ""), in d1, which obviously returned "false."

Ideally, if c1="yes", I'd like a1 to equal b1, and then, subsequently, b1 to equal 0.

Any thoughts?

Thanks in advance.

 

[Oaktree]

You cannot use a formula to change the value of another cell. You could, however, add columns called "adjusted spent" (column D)and "adjusted encumbered" (column E).

D2 = if(c2="yes",b2,a2)
E2 = if(c2="yes",0,b2)