![]() |
"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? |
"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? |
"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? |
"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 |
"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? |
"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? |
"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