IF function with conditions

[Siberian]

I want cell B to increase or decrease by some set amount based on whether or not cell A contains 0 or 1. But if it's decreasing (cell A being 1), I want cell B to have a lower limit. I'm guessing this is an IF struggle that just confuses me, but I'm not sure Any ideas?

[Pete_UK]

If you want a lower limit your can use the MAX function, although it doesn't seem instinctive until you think about it, e.g.:

=MAX(0,some_variable)

where some_variable could increase or decrease but the function will never return anything lower than zero (in this example).

If you want the formula in B1 to act upon the value in B1, you will have to enable iteration to avoid circular reference errors.

It would help if you attached a sample Excel workbook - see the yellow banner at the top of the screen to find out how to do this.

Hope this helps.

Pete