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.

Thanks

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

Thanks, Claus. I did figure it out, :-). This worked too.

=SUM(A1/0.18)


=A1/18*100


Regards

Claus Busch

Win XP PRof SP2 / Vista Ultimate SP2

Office 2003 SP2 /2007 Ultimate SP2