If/Then Formula for Inventory spreadsheet

[JustinFincher]

I need some help with a formula in Google Docs.
It's an inventory spreadsheet, so I have a column for 'need', 'got ' and' to order '. I need to subtract need from got and have that number to to the order column. If that number is negative due to having more than I need, I need the answer to be 0.
I also have a table that has current pricing so the needed order is calculated accordingly.
The whole idea is that I can manage pricing and inventory and see what my current nominal stock would cost.

I used to know how to do this, I just haven't written any formulas in a long time.
I have a link to a copy of the spreadsheet for anyone interested.
Thanks!

 

[dgyang]

You try this formula in your spreadsheet:

=IF(A1-B1<0,0,A1-B1)

Assume column A is for "Need" and column B is for "Got". You need to adjust the column reference to your specific columns.

 

[JustinFincher]

You try this formula in your spreadsheet:

=IF(A1-B1<0,0,A1-B1)

Assume column A is for "Need" and column B is for "Got". You need to adjust the column reference to your specific columns.

I'll try this ASAP. Thanks for the speedy reply!

 

[bschwartz]

Or:

Excel 2010
	A	B	C
1	Need	Got	To Order
2	15	5	10
3	10	20	0
Sheet12

Cell Formulas
Range	Formula
C2	=MAX(A2-B2,0)