"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?
|