Formula for multiplying with rounding included


Okay, so I need to come up with a formula that does 2 things:

  1. Multiples the numbers in ColumnA with the numbers in ColumnB
  2. Rounds those numbers up or down depending on what the nearest .5% is

For example:

ColumnA has 6 in it

ColumnB has 70% in it

Multiplying those together, gives me 4.2. I need that to automatically round down to 4 since 4.2 is closer to 4 than it is to 4.5.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!