"Kevins" wrote in message
...
Hello,
I have a spread sheet which tracks whether an item has been paid or not.
It
also looks at the amount claimed and compares this to the amount paid and
returns either "PAID", "UNDERPAID" or "OVERPAID". The problem is, if the
amount paid cell is blank the status defaults to "PAID". Any ideas?

It's easier if you post your formula. But try this (for amount paid in cell
A1):
=IF(A1="","",put_your_formula_here)