no negative numbers

[ParrotHead]

I have a formula that can generate a negative number ie (a-b)*.2 = c. If c is a negative number I want a 0 to be placed in that cell. Is this possible? The cell is formated for currency.

 

[IML]

you could use
=max(0,(a-b)*.2)

 

[Jay Petrulis]

On 2002-04-22 15:16, ParrotHead wrote:
I have a formula that can generate a negative number ie (a-b)*.2 = c. If c is a negative number I want a 0 to be placed in that cell. Is this possible? The cell is formated for currency.

I don't know your exact formula, but

=MAX(0,(a-b)*.2 )

would give you what you want. This would be more eficient that an IF statement for this.

Bye,
Jay