Discussion Equation Problem in Excel
https://techcommunity.microsoft.com/t5/excel/equation-problem/m-p/2338722#M99262
<P><STRONG>=IF(D2>=K1,2017,IF(D2>=L1,2018," "))</STRONG></P><P>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?</P>Sun, 09 May 2021 09:16:42 GMTmahbcat2021-05-09T09:16:42ZEquation Problem
https://techcommunity.microsoft.com/t5/excel/equation-problem/m-p/2338722#M99262
<P><STRONG>=IF(D2>=K1,2017,IF(D2>=L1,2018," "))</STRONG></P><P>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?</P>Sun, 09 May 2021 09:16:42 GMThttps://techcommunity.microsoft.com/t5/excel/equation-problem/m-p/2338722#M99262mahbcat2021-05-09T09:16:42ZRe: Equation Problem
https://techcommunity.microsoft.com/t5/excel/equation-problem/m-p/2338739#M99263
<P><LI-USER uid="1049023"></LI-USER> </P>
<P>What exactly do you mean by "I want use K1 and L1 as data"?</P>
<P>Does</P>
<P><STRONG>=IF(D2>=$K$1,2017,IF(D2>=$L$1,2018,""))</STRONG></P>
<P>do what you want?</P>Sun, 09 May 2021 09:23:47 GMThttps://techcommunity.microsoft.com/t5/excel/equation-problem/m-p/2338739#M99263Hans Vogelaar2021-05-09T09:23:47ZRe: Equation Problem
https://techcommunity.microsoft.com/t5/excel/equation-problem/m-p/2339509#M99320
Please share a sample of what you are trying to accomplish. Thank you.Sun, 09 May 2021 23:34:26 GMThttps://techcommunity.microsoft.com/t5/excel/equation-problem/m-p/2339509#M99320Yea_So2021-05-09T23:34:26Z