I'm trying to use an if statement to tell me if a cell has $0.00 and then to place "complete" in the formula cell. Any other value (even blank) should leave cell blank. Formula cell is m2
Here's what i've tried so far that doesn't work. What usually happens when I do get the formula to register is that it records "complete" even if the cell is blank.
Formula:
Please Login or Register to view this content.
Formula:Please Login or Register to view this content.
What's the formula in M2?
If posting code please use code tags, see here.
Sorry for the confusion. Those are the formulas I've used in m2.
It's my mistake.
What's the formula in I2?
No formula. It formatted for currency so it either has a value greater than 0, the value 0, or blank.
Any chance you could upload a sample workbook?
Click on GO ADVANCED, scroll down and click Manage Attachments.
See attached.
Try this.
Please Login or Register to view this content.
Thanks that worked. I always forget to use <> instead. I forgot why that works though. If you have time, could you explain why? Thanks again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks