Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Office For Mac
Mac Office Excel
Excel formula; all negative values return with 0
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="ranthny, post: 6815756"] Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel I created a formula that counts up elective courses in a spread sheet row that someone needs to take. Example: =3-COUNTA(O26:W26) Problem is that they can take many different ones, but are only required to take three. When I get negative numbers, is there a way I can build them formula to return all negative numbers to zero? [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Office For Mac
Mac Office Excel
Excel formula; all negative values return with 0
Top
