Need formula

Question

If a cell is IN can you change a other value in a other cell into - or +

For example

when the warehiuse scan the goods in , and action is IN , and QTY 20 the qty 20 doesnt changes .

But when action is OUT the number he puts in the field is 6 but due to the action is OUT the number shoudl changes to -6

This make that i can create a warehouse overvieuw

Protonsponge · Accepted Answer

Hello @TVP ALAN

Would the following be an option for you? For each row, if [ACTION] equals "IN" then it will display the value in [QTY], if [ACTION] equals "OUT", it will display the negative value in [QTY].

=IF(Action@row = "IN", QTY@row, IF(Action@row = "OUT", -QTY@row))

I hope that is helpful to you in some way,

Protonsponge