software

Is there a way to find the lowest amp; highest number in a range of columns, and
perform a calculation on them, e.g. %change (to-fm)/fm% Thanks

What relationship do quot;toquot; and quot;fmquot; have to the lowest and highest number?

If quot;toquot; is the lowest number in columns A:J, and quot;fmquot; is the highest
number in columns A:J:

=MIN(A:J)/MAX(A:J) - 1

formatted as a percentage.

In article gt;,
quot;nastechquot; gt; wrote:

gt; Is there a way to find the lowest amp; highest number in a range of columns, and
gt; perform a calculation on them, e.g. %change (to-fm)/fm% Thanks

thanks!

quot;JE McGimpseyquot; wrote:

gt; What relationship do quot;toquot; and quot;fmquot; have to the lowest and highest number?
gt;
gt; If quot;toquot; is the lowest number in columns A:J, and quot;fmquot; is the highest
gt; number in columns A:J:
gt;
gt; =MIN(A:J)/MAX(A:J) - 1
gt;
gt; formatted as a percentage.
gt;
gt; In article gt;,
gt; quot;nastechquot; gt; wrote:
gt;
gt; gt; Is there a way to find the lowest amp; highest number in a range of columns, and
gt; gt; perform a calculation on them, e.g. %change (to-fm)/fm% Thanks
gt;

thanks again. that was good, found that a similar equation I have, is
using up alot of memory in my file. Equation is for same range, but using
quot;choicesquot; of 2, 3, or 4 periods of input (so I repeated the same equation, 4
times: 1st time is if end of day: 1st column emptied): was wondering if
there might be a simpler way to calculate? thanks

=IF(AK9=quot;quot;,quot;quot;,
IF(AND(AL9lt;gt;quot;quot;,COUNTA(AL9:AM9)lt;gt;0,OR($O$2={quot;quot;,quot;.quot;, 2})),IF(AK9gt;AVERAGE(AL9:AM9),quot;Uquot;,IF(AK9lt;AVERAGE(AL 9:AM9),quot;Dquot;,quot;Fquot;)),
IF(AND(COUNTA(AM9:AN9)lt;gt;0,OR($O$2={quot;quot;,quot;.quot;,2})),IF( AK9gt;AVERAGE(AM9:AN9),quot;Uquot;,IF(AK9lt;AVERAGE(AM9:AN9),quot; Dquot;,quot;Fquot;)),
IF(AND(COUNTA(AL9:AN9)lt;gt;0,$O$2=3),IF(AK9gt;AVERAGE(A L9:AN9),quot;Uquot;,IF(AK9lt;AVERAGE(AL9:AN9),quot;Dquot;,quot;Fquot;)),
IF(AND(COUNTA(AL9:AO9)lt;gt;0,$O$2=4),IF(AK9gt;AVERAGE(A L9:AO9),quot;Uquot;,IF(AK9lt;AVERAGE(AL9:AO9),quot;Dquot;,quot;Fquot;)),quot;quot;)) )))
quot;JE McGimpseyquot; wrote:

gt; What relationship do quot;toquot; and quot;fmquot; have to the lowest and highest number?
gt;
gt; If quot;toquot; is the lowest number in columns A:J, and quot;fmquot; is the highest
gt; number in columns A:J:
gt;
gt; =MIN(A:J)/MAX(A:J) - 1
gt;
gt; formatted as a percentage.
gt;
gt; In article gt;,
gt; quot;nastechquot; gt; wrote:
gt;
gt; gt; Is there a way to find the lowest amp; highest number in a range of columns, and
gt; gt; perform a calculation on them, e.g. %change (to-fm)/fm% Thanks
gt;