I am using solver on a chain of cells. If one of the cells contains a ROUND function, such as =ROUND((C16-D16)*$D$12+D16,0), solver returns an incorrect answer. If I remove the ROUND function, such as (C16-D16)*$D$12+D16, solver returns the correct answer. Any ideas on why solver does not like the ROUND function?
Bookmarks