"IF" Formulae

[Guest]

I'm trying to create a formula causing one of three answers. The object
being any one of 0, 1 or >1. I need 0 an >1 to answer "years" and 1 to
answer "year". My efforts below.

=IF(G8>1,"years","year")*IF(G8<1,"years")

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

 

[Guest]

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

=if(G8=1,"year","years")

HTH,
Elkar

 

[Guest]

You need to add the two formulas together. Try:
=IF(G8>1, "years","year")+IF(G8<1,"years")
In all reality, you shouldn't even need the second formula, but try that
above and it should work.

 

[Dave Peterson]

=if(g8=1,"year","years")

or
="year"&if(g8=1,"","s")

 

[Guest]

Much thanks. I was making it too complicated.

You need to add the two formulas together. Try:
=IF(G8>1, "years","year")+IF(G8<1,"years")
In all reality, you shouldn't even need the second formula, but try that
above and it should work.

 

[Bob Phillips]

="year"&IF(G8>1,"s","")

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Roger Govier]

Hi Libby

But what if G8 is negative?
Perhaps =IF(ABS(G8)=1,"year","years")