Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by jlbCodeman
-
excel formula help in rounding numbers
Thank you so much. That did what I wanted. I kind of thought something like an IF would be involved but I am not that math savvy with developing formulas. You guys are a great help.- jlbCodeman
- Post #3
- Forum: Microsoft: Office
-
excel formula help in rounding numbers
I am trying to round a number following rounding rules. However, I find that when the number is a negative result I would like all negative numbers to be zero. I can get the answer to round properly but I cannot figure out how to get the negative answer number to always be zero. ex: 0 - 4.2 =...- jlbCodeman
- Thread
- Replies: 4
- Forum: Microsoft: Office
