=IF(A1=0,0,IF(A1<301,495,IF(A1300,795,"")))

If this post helps click Yes
---------------
Jacob Skaria


"Jayceejay" wrote:

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?