Thread: Blank cell
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Kevins Kevins is offline
external usenet poster
 
Posts: 11
Default Blank cell

Brilliant Stephen - does the job perfectly!
Now I can get back to something more productive.
Good luck and many thanks.

"Stephen" wrote:

So,
=IF(G13="","",IF(G13F13,"OVERPAID","PAID"))

"Kevins" wrote in message
...
Stephen, thanks for the help.
Here's the original formula.
=IF(G13F13,"OVERPAID","PAID")
I'm looking for the formula to only return a value in
cell I13 if there is a value in G13.


"Stephen" wrote:

"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)