Forum Discussion
VikkiJ
Nov 19, 2019Copper Contributor
I need a IFS statement for it to compare dates. If A2 less than 1 year then X If a2 more than 1 yea
need a statement that will look at a cell and determine the following less then 1 yr then put a 1 more than 1 less then 3 put a 2 more than 3 less then 4 put a 3 more than 4 less then 5 put a ...
Twifoo
Nov 19, 2019Silver Contributor
The Boolean alternative would be:
=INT(A1)+
(A1<2)-
INT(A1-8)*
(A1>=9)
=INT(A1)+
(A1<2)-
INT(A1-8)*
(A1>=9)