Formula for multiplying with rounding included

Tiara Rea-Palmer

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.

Brucey

Hey @Tiara Rea-Palmer

1. the formula is pretty simple =[Column4]@row * [Column5]@row (the * character multiplies)
2. Have you tried using this on your tool bar :

The 0 figures with the arrows shift the decimal places and will do what you've asked !

Tiara Rea-Palmer

hmm, the icons move the decimal but they don't round the numbers. For example, if I have 4.2, I need it to automatically round down to 4 or if there's 4.4, it should round up to 4.5.