If function

Office

Please can someone tell me the formula I need if a box is ticked how to move an amount to a different column.

so If mikes ticks is ticked how can I move the amount to amount outstanding.

thank you

Sue

Chris McKay

Hi Sue,

That's a pretty vague description, but never let it be said that I don't like a challenge, so I'll have a go.

Let's say you have 3 columns:

1. Checkbox(Checkbox format)
2. Amount Before(Text/Number format)
3. Amount After(Text/Number format)

You'll want to put your formula in the column you are "moving" the amount into. You are not technically moving anything toAmount After, just referencing the value inAmount Before.

The formula you need to enter in the first row of theAmount Aftercolumn is:

=IF(Checkbox1,[Amount Before]1,"")

I'd copy this formula down a few rows and lock theAmount Aftercolumn (right-click on the column header and choose Lock) to ensure nobody accidentally edits/deletes your formula.

The formula will copy itself down theAmount Aftercolumn as new rows are populated.

Mike Wilday

You won't be able to "move" an amount per-se, but if you use Chris' formula in the Amount Outstanding column it should copy that amount to that column if the checkbox is ticked. Otherwise, that amount will be 0.

Office

Thank you

will try this.

sue