May 09 2021 02:16 AM
=IF(D2>=K1,2017,IF(D2>=L1,2018," "))
I am using this equation. But in this equation I want use K1 and L1 as data. But excel is reading them as cell. What can I do?
May 09 2021 02:22 AM - edited May 09 2021 02:23 AM
What exactly do you mean by "I want use K1 and L1 as data"?
Does
=IF(D2>=$K$1,2017,IF(D2>=$L$1,2018,""))
do what you want?
May 09 2021 04:34 PM