ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   "IF" Formulae (https://www.excelbanter.com/excel-discussion-misc-queries/64036-if-formulae.html)

Libby

"IF" Formulae
 
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(G81,"years","year")*IF(G8<1,"years")

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

Elkar

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

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

HTH,
Elkar

"Libby" wrote:

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(G81,"years","year")*IF(G8<1,"years")

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


NUMBnut

"IF" Formulae
 
You need to add the two formulas together. Try:
=IF(G81, "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.

"Libby" wrote:

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(G81,"years","year")*IF(G8<1,"years")

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


Dave Peterson

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

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

Libby wrote:

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(G81,"years","year")*IF(G8<1,"years")

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


--

Dave Peterson

Libby

"IF" Formulae
 
Much thanks. I was making it too complicated.

"NUMBnut" wrote:

You need to add the two formulas together. Try:
=IF(G81, "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.

"Libby" wrote:

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(G81,"years","year")*IF(G8<1,"years")

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


Bob Phillips

"IF" Formulae
 
="year"&IF(G81,"s","")

--

HTH

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


"Libby" wrote in message
...
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(G81,"years","year")*IF(G8<1,"years")

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




Roger Govier

"IF" Formulae
 
Hi Libby

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


--
Regards

Roger Govier


"Libby" wrote in message
...
Much thanks. I was making it too complicated.

"NUMBnut" wrote:

You need to add the two formulas together. Try:
=IF(G81, "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.

"Libby" wrote:

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(G81,"years","year")*IF(G8<1,"years")

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





All times are GMT +1. The time now is 03:48 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com