no negative numbers

ParrotHead · Apr 22nd, 2002, 04:16 PM

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 · Apr 22nd, 2002, 04:18 PM

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

Jay Petrulis · Apr 22nd, 2002, 04:20 PM

Quote:

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 22nd, 2002, 04:16 PM	#1
ParrotHead New Member Join Date: Apr 2002 Posts: 1	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.

Apr 22nd, 2002, 04:18 PM	#2
IML MrExcel MVP Join Date: Feb 2002 Location: Denver, CO Posts: 1,744	you could use =max(0,(a-b)*.2)