Quote:
Originally Posted by required_username
In my case, the values are $0.00 so exact is a necessity. I'll try "ROUND" and see if it solves my problem. I would expect I can avoid teh middle man and have the value in C2 calculated as =ROUND(R7*J2+J5,2). Correct?
|
Sure, you can. All it cares is that it has some kind of numeric value to work with. Sometimes in my anxiety to boil things down to as few steps as possible I combine so many things into one that it gets much harder to understand; in such a case if I overdo it, it's sometimes better to break it up into pieces. But you're not near that threshold here..