Compare two sets of data with multiple conditions

[Nyeknyok]

Hi I am trying to compare two sets of data by having indicators if they increased, decreased, or stayed the same.

Something like this:
If D6 = J6 then K6.Value = 0
If D6 > J6 then K6.Value = 1
If D6 < J6 then K6.Value = 2

I got it working with this:

Please Login or Register  to view this content.

but I got stuck, since I wanted to add a condition that if the word "NULL" or "/" appears on a cell then it would do the opposite.
I've tried adding another IF condition to the formula but I couldn't make it work.


Sample.PNG


Thank you in advance!

[AliGW]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. As you are new, I will do it for you this time.)

[Nyeknyok]

My apologies, I will take note of this for next time. Thank you for fixing my post.