Help entering Equation in Excel

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

I have an excel spreadsheet that has a list of numbers
that are 55% of a total that is unknown. Is there a way
I can create a formula to figure out the total in a cell?

Example:

26 - 55% of total

My equation is:

..55 * x = 26

I need to solve for x.

Is there a way to solve this in a cell?
 
Can't you just divide 26 by .55?

x=26/.55 ?

If you have a string in a cell, A1 try
=--LEFT(A1,3)/.55
 
Gee - can you tell it's been awhile since I had a math
class? DOH! Thanks for jumpstarting my brain!
 
Back
Top