ExcelBanter - Returning the x value of a formula

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Returning the x value of a formula (https://www.excelbanter.com/excel-discussion-misc-queries/12850-returning-x-value-formula.html)

Mental Block

Returning the x value of a formula

The value of "cell A1" is "cell A2" percent of X. How do I write a formula
in cell A3 that will always return X.

Bernd Plumhoff

=a1/a2%

HTH,
Bernd

All times are GMT +1. The time now is 01:11 PM.