Automatically shifting data into designated columns

[JohnDoe558]

I want to create a system where data entered in column A is automatically sorted to column B and C meeting certain conditions. For example, when I enter a positive(>= 0) value like $5,000, it should go automatically to B and when I enter a negative value, (< 0) like -$5,000, it should automatically go to column C.

Column A should not be visible during printout.

[Villeroy]

Very easy to do with a database but not with a spreadsheet.

[LeroyG]

if_columns.ods (8.7 KB)