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

@mahbcat 

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?

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