software

I'm trying to create a formula causing one of three answers. The object
being any one of 0, 1 or gt;1. I need 0 an gt;1 to answer quot;yearsquot; and 1 to
answer quot;yearquot;. My efforts below.

=IF(G8gt;1,quot;yearsquot;,quot;yearquot;)*IF(G8lt;1,quot;yearsquot;)

My problem is that I can't override the first false conclusion. Any
suggestions?

Seems to me that you really only have two options (1 or Not 1). Try this:

=if(G8=1,quot;yearquot;,quot;yearsquot;)

HTH,
Elkar

quot;Libbyquot; wrote:

gt; I'm trying to create a formula causing one of three answers. The object
gt; being any one of 0, 1 or gt;1. I need 0 an gt;1 to answer quot;yearsquot; and 1 to
gt; answer quot;yearquot;. My efforts below.
gt;
gt; =IF(G8gt;1,quot;yearsquot;,quot;yearquot;)*IF(G8lt;1,quot;yearsquot;)
gt;
gt; My problem is that I can't override the first false conclusion. Any
gt; suggestions?

You need to add the two formulas together. Try:
=IF(G8gt;1, quot;yearsquot;,quot;yearquot;) IF(G8lt;1,quot;yearsquot;)
In all reality, you shouldn't even need the second formula, but try that
above and it should work.

quot;Libbyquot; wrote:

gt; I'm trying to create a formula causing one of three answers. The object
gt; being any one of 0, 1 or gt;1. I need 0 an gt;1 to answer quot;yearsquot; and 1 to
gt; answer quot;yearquot;. My efforts below.
gt;
gt; =IF(G8gt;1,quot;yearsquot;,quot;yearquot;)*IF(G8lt;1,quot;yearsquot;)
gt;
gt; My problem is that I can't override the first false conclusion. Any
gt; suggestions?

=if(g8=1,quot;yearquot;,quot;yearsquot;)

or
=quot;yearquot;amp;if(g8=1,quot;quot;,quot;squot;)

Libby wrote:
gt;
gt; I'm trying to create a formula causing one of three answers. The object
gt; being any one of 0, 1 or gt;1. I need 0 an gt;1 to answer quot;yearsquot; and 1 to
gt; answer quot;yearquot;. My efforts below.
gt;
gt; =IF(G8gt;1,quot;yearsquot;,quot;yearquot;)*IF(G8lt;1,quot;yearsquot;)
gt;
gt; My problem is that I can't override the first false conclusion. Any
gt; suggestions?

--

Dave Peterson

Much thanks. I was making it too complicated.

quot;NUMBnutquot; wrote:

gt; You need to add the two formulas together. Try:
gt; =IF(G8gt;1, quot;yearsquot;,quot;yearquot;) IF(G8lt;1,quot;yearsquot;)
gt; In all reality, you shouldn't even need the second formula, but try that
gt; above and it should work.
gt;
gt; quot;Libbyquot; wrote:
gt;
gt; gt; I'm trying to create a formula causing one of three answers. The object
gt; gt; being any one of 0, 1 or gt;1. I need 0 an gt;1 to answer quot;yearsquot; and 1 to
gt; gt; answer quot;yearquot;. My efforts below.
gt; gt;
gt; gt; =IF(G8gt;1,quot;yearsquot;,quot;yearquot;)*IF(G8lt;1,quot;yearsquot;)
gt; gt;
gt; gt; My problem is that I can't override the first false conclusion. Any
gt; gt; suggestions?

=quot;yearquot;amp;IF(G8gt;1,quot;squot;,quot;quot;)

--

HTH

RP
(remove nothere from the email address if mailing direct)quot;Libbyquot; gt; wrote in message
...
gt; I'm trying to create a formula causing one of three answers. The object
gt; being any one of 0, 1 or gt;1. I need 0 an gt;1 to answer quot;yearsquot; and 1 to
gt; answer quot;yearquot;. My efforts below.
gt;
gt; =IF(G8gt;1,quot;yearsquot;,quot;yearquot;)*IF(G8lt;1,quot;yearsquot;)
gt;
gt; My problem is that I can't override the first false conclusion. Any
gt; suggestions?
Hi Libby

But what if G8 is negative?
Perhaps =IF(ABS(G8)=1,quot;yearquot;,quot;yearsquot;)--
Regards

Roger Govierquot;Libbyquot; gt; wrote in message
...
gt; Much thanks. I was making it too complicated.
gt;
gt; quot;NUMBnutquot; wrote:
gt;
gt;gt; You need to add the two formulas together. Try:
gt;gt; =IF(G8gt;1, quot;yearsquot;,quot;yearquot;) IF(G8lt;1,quot;yearsquot;)
gt;gt; In all reality, you shouldn't even need the second formula, but try
gt;gt; that
gt;gt; above and it should work.
gt;gt;
gt;gt; quot;Libbyquot; wrote:
gt;gt;
gt;gt; gt; I'm trying to create a formula causing one of three answers. The
gt;gt; gt; object
gt;gt; gt; being any one of 0, 1 or gt;1. I need 0 an gt;1 to answer quot;yearsquot; and
gt;gt; gt; 1 to
gt;gt; gt; answer quot;yearquot;. My efforts below.
gt;gt; gt;
gt;gt; gt; =IF(G8gt;1,quot;yearsquot;,quot;yearquot;)*IF(G8lt;1,quot;yearsquot;)
gt;gt; gt;
gt;gt; gt; My problem is that I can't override the first false conclusion.
gt;gt; gt; Any
gt;gt; gt; suggestions?