If your numbers are in a1:a4
=LEFT(SUM(A1:A4),2)+IF(MID(SUM(A1:A4),3,1)*1>=5,1,0)
take the leftmost 2 characters, then if the 3rd character is >=5 add 1 to the answer
If your numbers are in a1:a4
=LEFT(SUM(A1:A4),2)+IF(MID(SUM(A1:A4),3,1)*1>=5,1,0)
take the leftmost 2 characters, then if the 3rd character is >=5 add 1 to the answer
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks