How to insert text based on value

July 7, 2017 at 18:24:59
Specs: Windows 10
My assignment is: in column G to remind of expenses that require receipts for the rows that are more than or equal to 100.00 and print the word "Yes" all other row leave blank

See More: How to insert text based on value

Reply ↓  Report •

#1
July 7, 2017 at 20:49:27
First, a posting tip...

When posting in a Help forum such as this, please try to use a Subject Line that tells us something about your question. If everyone used a generic Subject Line such as yours, we wouldn't be able to tell one question from another and the Archives would essentially be useless.

I have edited the subject line of your post to show you what I mean. Scan the list of questions in this forum to see the types of Subject Lines that others have used.

As for your question, it is not clear what you mean by "rows that are more than or equal to 100.00“.

A row can't be equal to a value. A cell could be equal to a value or the SUM of certain cells in a row could be equal to a value, but a row can't be equal to anything.

What exactly are you checking for to see if it is more than or equal to 100.00?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Reply ↓  Report •
Related Solutions


Ask Question