ExcelBanter - Solve for a number (x)

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Solve for a number (x) (https://www.excelbanter.com/excel-worksheet-functions/447188-solve-number-x.html)

RG[_4_]

Solve for a number (x)

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

Claus Busch

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

[email protected]

Solve for a number (x)

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

All times are GMT +1. The time now is 10:40 PM.