Discussion Re: variables in Excel
https://techcommunity.microsoft.com/t5/excel/variables/m-p/3043061#M126765
<P><LI-USER uid="1254823"></LI-USER> </P><P> </P><P>Enter =8000/(4540*PI()) into A1. The value appears to be 0.5608984778569, when formatted as Number with 15 decimal places.</P><P> </P><P>Enter =SQRT(A1) into A2. The value appears to be <FONT color="#FF0000">0.74893155</FONT>7525052. If you want that truncated to 8 decimal places, write =TRUNC(SQRT(A1) xxx) .</P><P> </P><P>(ERRATA.... This forum's applet is having trouble posting what I typed! I am trying to find a work-around. Replace "xxx" with ", 8" -- comma 8.)</P><P> </P><P>Although we can name cells, we cannot use names that look like cell or column identifiers, for example "r" and "x". And we cannot use symbols in names, for example "r^2" and "x^2".</P><P> </P><P>We can simply __think__ of A1 as r^2 and A2 as "r". Alternatively, make up names that make sense to you; but again, they must be unambiguous.</P>Mon, 20 Dec 2021 21:57:30 GMTJoe User2021-12-20T21:57:30Zvariables
https://techcommunity.microsoft.com/t5/excel/variables/m-p/3042012#M126591
<P>Having trouble with an equation, it should be 8000/(4540*pi*1)=r^2. r^2= should equal 0.74893155. but it does not, I could not do "=r^2" or "=x^2" as the variable is undefined, please help!</P>Sun, 19 Dec 2021 03:46:54 GMThttps://techcommunity.microsoft.com/t5/excel/variables/m-p/3042012#M126591Mcdwog2021-12-19T03:46:54ZRe: variables
https://techcommunity.microsoft.com/t5/excel/variables/m-p/3042984#M126749
<P><LI-USER uid="1254823"></LI-USER> </P>
<P>Not sure what exactly you'd try to find.</P>
<P>=8000/(4540*PI()*1) returns 0.560898 which is 0.748932^2</P>Mon, 20 Dec 2021 19:55:42 GMThttps://techcommunity.microsoft.com/t5/excel/variables/m-p/3042984#M126749Sergei Baklan2021-12-20T19:55:42ZRe: variables
https://techcommunity.microsoft.com/t5/excel/variables/m-p/3043061#M126765
<P><LI-USER uid="1254823"></LI-USER> </P><P> </P><P>Enter =8000/(4540*PI()) into A1. The value appears to be 0.5608984778569, when formatted as Number with 15 decimal places.</P><P> </P><P>Enter =SQRT(A1) into A2. The value appears to be <FONT color="#FF0000">0.74893155</FONT>7525052. If you want that truncated to 8 decimal places, write =TRUNC(SQRT(A1) xxx) .</P><P> </P><P>(ERRATA.... This forum's applet is having trouble posting what I typed! I am trying to find a work-around. Replace "xxx" with ", 8" -- comma 8.)</P><P> </P><P>Although we can name cells, we cannot use names that look like cell or column identifiers, for example "r" and "x". And we cannot use symbols in names, for example "r^2" and "x^2".</P><P> </P><P>We can simply __think__ of A1 as r^2 and A2 as "r". Alternatively, make up names that make sense to you; but again, they must be unambiguous.</P>Mon, 20 Dec 2021 21:57:30 GMThttps://techcommunity.microsoft.com/t5/excel/variables/m-p/3043061#M126765Joe User2021-12-20T21:57:30Z