Both of these formulas return the values you seem to be expecting if the formula is placed in any cell.

If you're placing the formula in cell A2, it will cause a circular reference. Might help to clarify where you're putting the formula.