LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Pat
 
Posts: n/a
Default IF Statement help...

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
If..then statement sheila_d_pratt Excel Discussion (Misc queries) 2 March 7th 05 11:07 PM
What statement to use? Paul Excel Worksheet Functions 6 February 13th 05 05:23 PM
How do I fix a circular reference in a financial statement? drjayhawk25 Excel Discussion (Misc queries) 0 February 7th 05 05:19 PM
7+ nested if statement? Turi Excel Worksheet Functions 3 December 20th 04 07:55 PM
Statement lintan Excel Worksheet Functions 1 December 2nd 04 11:31 PM


All times are GMT +1. The time now is 03:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"