software

Is there a way of creating an IF function resulting in many options such as:
B3gt;6 quot;Highquot;
B3 Between 6 and 0 quot;Lowquot;
B3lt;0 quot;Negativequot;

Hi

Try something like this:
=IF(B3gt;6,quot;Highquot;,IF(B3lt;0,quot;Negativequot;,quot;Lowquot;))

Hope this helps.
Andy.quot;Phippsyquot; gt; wrote in message
...
gt; Is there a way of creating an IF function resulting in many options such
gt; as:
gt; B3gt;6 quot;Highquot;
gt; B3 Between 6 and 0 quot;Lowquot;
gt; B3lt;0 quot;Negativequot;
Excellent thanks

quot;Andyquot; wrote:

gt; Hi
gt;
gt; Try something like this:
gt; =IF(B3gt;6,quot;Highquot;,IF(B3lt;0,quot;Negativequot;,quot;Lowquot;))
gt;
gt; Hope this helps.
gt; Andy.
gt;
gt;
gt; quot;Phippsyquot; gt; wrote in message
gt; ...
gt; gt; Is there a way of creating an IF function resulting in many options such
gt; gt; as:
gt; gt; B3gt;6 quot;Highquot;
gt; gt; B3 Between 6 and 0 quot;Lowquot;
gt; gt; B3lt;0 quot;Negativequot;
gt;
gt;
gt;

Thanks for the feedback!

Andy.

quot;Phippsyquot; gt; wrote in message
...
gt; Excellent thanks
gt;
gt; quot;Andyquot; wrote:
gt;
gt;gt; Hi
gt;gt;
gt;gt; Try something like this:
gt;gt; =IF(B3gt;6,quot;Highquot;,IF(B3lt;0,quot;Negativequot;,quot;Lowquot;))
gt;gt;
gt;gt; Hope this helps.
gt;gt; Andy.
gt;gt;
gt;gt;
gt;gt; quot;Phippsyquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Is there a way of creating an IF function resulting in many options
gt;gt; gt; such
gt;gt; gt; as:
gt;gt; gt; B3gt;6 quot;Highquot;
gt;gt; gt; B3 Between 6 and 0 quot;Lowquot;
gt;gt; gt; B3lt;0 quot;Negativequot;
gt;gt;
gt;gt;
gt;gt;