Rounding

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to write a formula that multiplies the value of two different cells (A1,B1). If the product is not an integer the formula then rounds to the nearest integer. How would I do that? Thank you in advance.
 
ROUND(A1*B1,0)

--
Carl & Linda Brehm
Lake Lafourche Bird House
Hebert, LA
Keets, Tiels, GN Lories, Quakers
Mitred Conures, TAG's, Bourkes
Cages
Aspen said:
I would like to write a formula that multiplies the value of two different
Click to expand...
cells (A1,B1). If the product is not an integer the formula then rounds to
the nearest integer. How would I do that? Thank you in advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average rounded to nearest 0.50 4
Rounding to Multiples of Integers? 5
ROUNDING UP TO NEAREST 9 4
how to multiply two values and round the result 5
advice on rounding or ceilng a 24 hour time value 3
Round Down to the nearest multiple 2
Rounding and Multiplying 2
Rounding by .05 4

Back
Top