Thread: "IF" Formulae
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Libby
 
Posts: n/a
Default "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?