View Single Post
 
Old 09-08-2020, 12:00 AM
Marcia's Avatar
Marcia Marcia is offline Windows 7 32bit Office 2013
Expert
 
Join Date: May 2018
Location: Philippines
Posts: 527
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

Thank you. Tried both formulae and they're perfect. It is my first time to use the FLOOR function.
Edit: In the FLOOR formula, I thought I just need to change the 3 to 1 or 2 just like Arvi's. I was wrong so I will use Arvi's solution.

Last edited by Marcia; 09-08-2020 at 02:28 AM.
Reply With Quote