close

how do I use a % range for instance if f13 is 25-75% in a formula

=IF(AND(F13gt;=25%,F13lt;=75%),quot;yesquot;,quot;noquot;)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

quot;lasquot; gt; wrote in message
...
gt; how do I use a % range for instance if f13 is 25-75% in a formula
Bob

I have been working on this for hours...thank you for you assistance it
worked!

las

quot;Bob Phillipsquot; wrote:

gt; =IF(AND(F13gt;=25%,F13lt;=75%),quot;yesquot;,quot;noquot;)
gt;
gt; --
gt; HTH
gt;
gt; Bob Phillips
gt;
gt; (remove nothere from email address if mailing direct)
gt;
gt; quot;lasquot; gt; wrote in message
gt; ...
gt; gt; how do I use a % range for instance if f13 is 25-75% in a formula
gt;
gt;
gt;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()