If a number in column turns negative...

Hello community,

I do a lot of inventory management and I want to display proper backorder numbers and inventory levels.

For instance, a number in column A says -2, I want the column B to say -2 while switching the -2 in column A into a zero. The -2 in column A would be the inventory level and column B would be where I'd want to display backorders. The inventory level gets its input from 'total inventory level' minus 'sales of day' tabs. Is there a way to create this into an automated function?


Thank you

Not with a regular function/formula, but it would be possible with VBA

Well wait that depends... show me the formula as it is in Column A. If that is a formula reading from another source then you could do this with an IF...

Wrap the entire formula in an IF(FORMULA<0,0,FORMULA) and in B do IF(FORMULA<0,FORMULA,0) but again... this depends on what the contents of A actually is.

Cheers

EDIT - To FDibbins point, if these are static figures or values entered into A and you would like a formula to overwrite them...VBA is your source of Solution... so please share what is in the A column... or a small sample of the workbook is best, leaves no room for guessing.

Ele, I took it that the OP has a value in A1 that would then be shown in B1. A1 would then revert to 0, but B1 would maintain the original value

Yea I read a couple times over and thought that but this line...

The inventory level gets its input from 'total inventory level' minus 'sales of day' tabs

Kind of sounds like it may have a formula... so we need the OP to clear that up

I have been wrong before - could be again