View Single Post
  #2   Report Post  
JulieD
 
Posts: n/a
Default

Hi Pat

=IF(M84<"","",G84+1)
< means not equal to
so M84<""
says if M84 is not equal to nothing, ie it has something in it

Cheers
JulieD

"Pat" wrote in message
...
This may have been asked before but I had no idea what to search for. My
question is this:

Is it possible to make an IF Statement that says "If there is any value at
all in this cell, then leave the cell blank, if not then do this formula"

Here is my formula right now: =IF(M84=0,"",G84+1)
I'm pretty sure it's what I want, but I think Excel is reading a "blank
cell" as equal to "0", so I guess that's my problem. I apologize if this
doesn't make much sense and I can clarify if needed. I appreciate all
input
and suggestions!
Thank you,
Patrick