ResellerRatings Store Ratings - View Single Post - Excel Function

bacat · 10-18-2002, 02:54 PM

I am tracking fixed asset depletions and need my spreadsheet to subtract monthly depletion from original cost, until the value reaches $0.00 then I want the spreadsheet to reflect "$0.00" instead of a negative number.

What function will sum with the condition that - IF the value is less then .01 display 0?

Please HELP!!!

10-18-2002, 02:54 PM	#1 (permalink)
bacat Registered User Join Date: Oct 2002 Posts: 8	See today's most popular deals at » Excel Function - Need Help I am tracking fixed asset depletions and need my spreadsheet to subtract monthly depletion from original cost, until the value reaches $0.00 then I want the spreadsheet to reflect "$0.00" instead of a negative number. What function will sum with the condition that - IF the value is less then .01 display 0? Please HELP!!!