View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
 
Posts: 3,872
Default Solve for a number (x)

Hi,

Am Fri, 21 Sep 2012 06:07:30 -0700 (PDT) schrieb RG:

I need to solve for a number (x) based on another number, i.e.

$200 is 18% of what number?

If I put the $200 in my A column is it possible to have the "x" arrive in another column? I would apply the same formula to all columns, it will always be a number is 18% of what number.


=A1/18*100


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2