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!!