Hello,
I have been working in a spreadsheet with a really large data set and i need to identify a set based on 2 variables - not date related. Everything I have seen so far has a date in it and I have tried to copy those formulas, but get the error that says, "are you trying to create a formula?" Excel seems to see the =and then not recognize my input.
I tried to use a formula copying this:
=IF(AND(B1="NO",R1=>TODAY()+10))
and I tried to translate it to the following, which does NOT work:
=IF(AND(B1="E",R1=>"47500"))
Can anyone help me figure out what is wrong with my formula? Basically is the value in B is E and the value in R is below 47500, I need it to show me.
Thank you!!
I have been working in a spreadsheet with a really large data set and i need to identify a set based on 2 variables - not date related. Everything I have seen so far has a date in it and I have tried to copy those formulas, but get the error that says, "are you trying to create a formula?" Excel seems to see the =and then not recognize my input.
I tried to use a formula copying this:
=IF(AND(B1="NO",R1=>TODAY()+10))
and I tried to translate it to the following, which does NOT work:
=IF(AND(B1="E",R1=>"47500"))
Can anyone help me figure out what is wrong with my formula? Basically is the value in B is E and the value in R is below 47500, I need it to show me.
Thank you!!