I am trying to take two columns and say if column A is between 0.01 and 0.05 cents more than column B then show me the results. This is what I have tried
[allowed_amt]+(between 0.01 and 0.05)=[epd_amt]
[allowed_amt]between +0.01 and +0.05=[epd_amt]
The only thing that works is if I do it like this:
[allowed_amt]+0.05=[epd_amt] this result only shows me allowed_amt that is plus 0.05 cents compared to epd_amt. It does not give those that are 0.01 0.02 0.03 or 0.04 which I need anything between the 2 amounts.