I am having a difficult time with an IF statement.
I have a value in cell A1 that triggers a response in cell A5.
If cell A1 = 0, Cell A5 should =0
If cell A1 is 0and<=300,Cell A5 should =495
If cell A1 is 300, Cell A5 should =795.

The PROBLEM here is that I can't seem to use "and" conditions within an If
statement. I've tried "between" and "And" and that doesn't work either.
What am I doing wrong?