# If a number in column turns negative...

1. ## 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

2. ## Re: If a number in column turns negative...

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

3. ## Re: If a number in column turns negative...

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.

4. ## Re: If a number in column turns negative...

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

5. ## Re: If a number in column turns negative...

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

6. ## Re: If a number in column turns negative...

I have been wrong before - could be again

There are currently 1 users browsing this thread. (0 members and 1 guests)