answersLogoWhite

0


Best Answer

You have to convert the fraction to a decimal. For instance if what you wanted to divide by is in cell 1A then in cell 1B if you want to divide by 2/3you type =A1/0.666.

User Avatar

Wiki User

12y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you divide by fractions in excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Is there a shortcut key for fractions?

Not in Excel. Excel does not use fractions. If you need to use fractions, then turn them into decimals. You can represent 1/2 in excel with the formula =1/2.


What does it mean to multiply and divide fractions?

multiply and divide fractions!-.-


Why can you not divide fractions?

We deny the premise and maintain that you can divide fractions.


How do you divide whole fractions with simple fractions?

It is simple all u really do is divide reguarlly.......


What is divide fractions?

It is an instruction as to what you are required to do with some fractions.


Why do you invert fractions?

When you divide by fractions, you invert and multiply.


How do you change the dessimilar fractions to similar fractions?

to change dessimilar fractions to similar fractions you divide


Why is you impossible divide fractions?

Me is actually not impossible divide fractions. You just take the reciprocal of the dividend and multiply.


What does the arithmetic operator do in Excel?

The following are valid Excel operations for arithmetic in Excel:+ (plus)- (minus)/ (divide)* (multiply)^ (power of)The following are valid Excel operations for arithmetic in Excel:+ (plus)- (minus)/ (divide)* (multiply)^ (power of)The following are valid Excel operations for arithmetic in Excel:+ (plus)- (minus)/ (divide)* (multiply)^ (power of)The following are valid Excel operations for arithmetic in Excel:+ (plus)- (minus)/ (divide)* (multiply)^ (power of)The following are valid Excel operations for arithmetic in Excel:+ (plus)- (minus)/ (divide)* (multiply)^ (power of)The following are valid Excel operations for arithmetic in Excel:+ (plus)- (minus)/ (divide)* (multiply)^ (power of)The following are valid Excel operations for arithmetic in Excel:+ (plus)- (minus)/ (divide)* (multiply)^ (power of)The following are valid Excel operations for arithmetic in Excel:+ (plus)- (minus)/ (divide)* (multiply)^ (power of)The following are valid Excel operations for arithmetic in Excel:+ (plus)- (minus)/ (divide)* (multiply)^ (power of)The following are valid Excel operations for arithmetic in Excel:+ (plus)- (minus)/ (divide)* (multiply)^ (power of)The following are valid Excel operations for arithmetic in Excel:+ (plus)- (minus)/ (divide)* (multiply)^ (power of)


Where are the fractions?

The fractions are when you divide a whole number into equal parts


How can you divide fractions?

Yes.


Is the reciprocal used to divide fractions?

In order to divide two fractions, multiply the first times the reciprocal of the second.