I need to change the formula so that a zero is returned instead of a negative number when H9<E9.
=IF(H9>G9,H9-G9,IF(H9<G9,H9-E9,0))
I have not used Excel since the early 90's when taking a college class. I recently volunteered for a non-profit that desperately needs help and am building some spreadsheets so they can automate some of their record keeping. Any assistance is greatly appreciated.
Bookmarks