# how to enter this calculation

What do I need to enter into a cell for this example?

x*.04=500

I want it to output the value of x

First time here? Check out the FAQ!

how to enter this calculation

What do I need to enter into a cell for this example?

x*.04=500

I want it to output the value of x

0

You could as well use the Goal Seek (Tools menu). It is easy to handle.

0

As @JohnSUN said, the short way is to divide 500 by 0.04. However, we can also ask Calc to solve the algebra problem for us.

- Enter the following labels: "x" in A1,
`'.04`

in B1, "desired product" in C1, and "multiply" in D1. - Highlight row 2 and press Ctrl+1 (or
*Format -> Cells*). Use number format -1234.57 and press OK. - In A2, enter 1 as an initial guess for x. Enter 0.04 in B2 and 500 in C2.
- In D2, enter the formula
`=A2*B2`

. - Go to
*Tools -> Solver*. Target cell is $D$2, Optimize result to Value of $C$2, By changing cells $A$2. - Press Solve, then Keep Result. Now our answer is the value of x shown in A2.

Asked: ** 2017-11-01 08:31:21 +0100 **

Seen: **56 times**

Last updated: **Nov 01 '17**

How do I export a chart in an image format from LibreOffice Calc? [closed]

Are there plans for a "papercut" project for libreoffice [closed]

Is it normal for Calc goal seek to take very long? [closed]

Please refine "Search" in Calc - implement functions in Gnumeric [closed]

LibreOffice Calc will not link to external data via internet [closed]

Is there a LibreOffice .odt, .ods viewer for Android? [closed]

Why is Calc so much slower at opening/saving files than MS-Office? (win7 x64) [closed]

Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.

This is a joke? Funny... Type

`=500/0.04`

and get`12500`