Thread: [Solved] Round Down Sum Formula
View Single Post
 
Old 08-18-2023, 04:20 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default
Code:
=round(sum(b4:c4)/5,1)*5
In case you really want rounddown, then
Code:
=ROUNDDOWN(SUM(B4:C4)/5,1)*5
Reply With Quote