Forum Discussion

Copper Contributor

Mar 12, 2024

excell

If I have downloaded bank statements for a 12 month period how do I transfer all negative amounts into a separate column?

Silver Contributor

Mar 14, 2024

A 365 formula that amused me. Basically it creates a copy of the amounts with reversed signs and then selected the positive values.

= LET(
    signed, {1,-1}*amounts,
    IF(signed>0, signed, "")
  )

The idea would work without 365

= IF({1,-1}*amounts>0, {1,-1}*amounts, "")

but I like seeing the LET function