Forum Discussion

VikkiJ's avatar
VikkiJ
Copper Contributor
Nov 19, 2019

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 ...

Resources