We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

how do l divide 2430 dollars by 326 and make it equal 7.46

asked 2018-02-25 18:09:02 +0200

ebaragary@hotmail.com gravatar image

updated 2018-02-25 19:08:59 +0200

librebel gravatar image

doing spread sheet for my farm records and need to divide dollars by bushels to get average price when l use quotient feature it always give me whole number and when l round it gives me to many decimal points and won't let me convert to dollars

edit retag flag offensive close merge delete


added the tag "calc"

librebel gravatar imagelibrebel ( 2018-02-25 19:09:13 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-02-25 19:02:03 +0200

Ratslinger gravatar image


Quotient will only produce whole numbers so this is not wanted.

ROUND (from off-line help):

ROUND(Number; Count)
Returns Number rounded to Count decimal places. If Count is omitted or zero, the function rounds to the nearest integer. If Count is negative, the function rounds to the nearest 10, 100, 1000, etc.
This function rounds to the nearest number. See ROUNDDOWN and ROUNDUP for alternatives.

Implementing this results in:

image description

The result in C1 used the formula =ROUNDUP(A1/B1,2) to produce your desired result.

The result in C2 used the formula =A1/B1.

The result in C3 used the formula =ROUND(2430/326,2)

How you want the result to display is simply formatting the cell - right mouse click cell & select Format Cells...

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-02-25 18:09:02 +0200

Seen: 922 times

Last updated: Feb 25 '18