Equation Problem

Occasional Visitor

=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?

2 Replies


What exactly do you mean by "I want use K1 and L1 as data"?



do what you want?

Please share a sample of what you are trying to accomplish. Thank you.