vanilladan
Board Regular
- Joined
- Sep 24, 2002
- Messages
- 145
Hello folks,
I'm writing a lot of IF statements at the moments which involve
themes such as:
=IF(A1+B1<0,0,A1+B1)
only much longer.
The idea of these formulas is, as above, to say:
"If the result is positive, return that positive result.
If the result is negative, return a 0."
(It's a purchasing system, so you can't buy in negative stock, i.e. -12 apples).
What I want to know is, if there an easier way to do this
because each formula uses a duplicate statement, which is a pain in large formulas.
Any ideas?
cheers,
Vanilladan
I'm writing a lot of IF statements at the moments which involve
themes such as:
=IF(A1+B1<0,0,A1+B1)
only much longer.
The idea of these formulas is, as above, to say:
"If the result is positive, return that positive result.
If the result is negative, return a 0."
(It's a purchasing system, so you can't buy in negative stock, i.e. -12 apples).
What I want to know is, if there an easier way to do this
because each formula uses a duplicate statement, which is a pain in large formulas.
Any ideas?
cheers,
Vanilladan