Good morning all.
Have not been here for a while. Always good though.
I need to round up cells which already have formula in them. I have looked on our site and have not found the answer though it may be there.
I have used ' =ROUND(E25+E26,0) to round up a simple calculation and as directed on this forum inserted my formula inside. Works great.
I am trying to use the same principle =ROUND(E24/(SUM(E17*$B$29))-D25),0) here without luck.
I attach a spread sheet if it’s any help. On the sheet are two identical sets of calculations with one showing the number expanded to show the decimal points.
Hope this helps. In London here and the sun is shining, it’s a glorious day.
All the Best Mark
For My Excel.xlsx
Bookmarks