How do I create a formula in Google Docs (spreadsheet) that shows 0 if X=<0?

I麓m trying to create a spreadsheet in Google Docs that calculates a cost when the sum is more then zero. Since the cost cannot be negative I need a formula that works in Google Spreadsheets, when x is lower then zero, then show zero.|||You are on the right track - the IF statement.



=IF ( test, then_true, otherwise_value )



=IF ( Cell %26lt;= 0, 0, Cell ) -- if the cell is less than or equal to zero, show zero, otherwise use the value in the cell.





The function's three arguments are:



test - a value or expression that is tested to see if it is true or false.

then_true - the operation that is carried out if the test is true.

otherwise_value - the operation that is carried out if the test is false.



Here's a more complete description, and links to other useful functions.



http://spreadsheets.about.com/od/othersp鈥?/a>



I hope this helps.