|First, may I suggest that you use some punctuation in your posts? In response #2 your first "sentence" should be at least 4 sentences separated by periods. Without punctuation, your posts are very difficult to read.|
As for your question, if B4 is available to "move" A4 into, i.e. it's empty, why not just use a formula in B4?
I see at least three options:
1 - Use the same formula in B4 as you use in A4 so you'll always see what's in A4.
2 - Put =A4 in B4. Again, you"ll always see whatever is in A4.
3 - Use an IF function in B4 so you'll only see the value in A4 when it's negative:
Another option is to use a macro that places the negative number in B4 or pops up a message box when A4 is negative or in some other way alerts you that A4 is negative. The possibilities are almost endless.
Regarding the question in Response # 3, try this:
In L8, use this:
In M8, use this:
With those 2 formulas, you will see a value in either L8 or M8, depending on whether the result of K8*M8 is positive or negative. However, I should point out that you didn't say what you want to happen if J8*K8 = 0. I assume that can never happen.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.