Hi,

I am using an IF/AND formula.
(=IF(AND(C4>=0, C4<=$A$1), "x", XXXX)

If the value is (TURE) less than A1 it returns an 'X' - This part is fine!
If the value is (FALSE) more than A1, I want it to return how much more than A1 it is.
Any help on the last part of this formula would be greatly appreciated