I am trying to create a formula to compute the following:
IF stop_living = 19 AND age> 19 THEN "18"
IF stop_living = 19 AND age <18 THEN age
Thanks in advance!
I am trying to create a formula to compute the following:
IF stop_living = 19 AND age> 19 THEN "18"
IF stop_living = 19 AND age <18 THEN age
Thanks in advance!
Hi and welcome
Maybe
=if(and(stop_living = 19,age >19),18,age)
Happy with my advice? Click on the * reputation button below
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks