can excel 2010 move a minus number from 1 cell to another using a formula i no how to cut & paste. thanks steve

✔ Best Answer

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:=IF(A4<0,A4,"")

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:

=IF(J8*K8>0,J8*K8,"")

In M8, use this:

=IF(J8*K8<0,J8*K8,"")

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.

A formula can not move a number. A formula can only return a value (or an error) in the cell in which it resides. A macro can "move" a number by reading the value in one cell, setting another cell to the same value and then deleting the original value. It doesn't really "move" the number but the end result is the same.

What exactly are you trying to do?

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

Thanks. I have written a couple of formulas for my account spreadsheet in excel 2010 my formulas return results in about 5 different columns the last column can return a minus result this is in a column not immediately on screen so i don't no until i scroll across by which time i have to go back to the row before the minus result and start again. What i need is something that will do this " if cell a4 is<0 then move number to cell b4" can this be done automatically so i don't have to scroll back and forth? Thanks Steve

I still can't do what i want it to do so off on another tact. Can a formula be written that says " if cell J8 multiplied by cell K8 is>0 put in cell L8 if <0 put in cell M8" ? Appreciate any ideas . Thanks Steve

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:=IF(A4<0,A4,"")

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:

=IF(J8*K8>0,J8*K8,"")

In M8, use this:

=IF(J8*K8<0,J8*K8,"")

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.

Thanks i have just got back to my problem and you have solved it. Everything works thanks again.

Ask Your Question

Weekly Poll

Do you think Monopoly should update its pieces?

Discuss in The Lounge

Poll History