How do I create a formula to skip blank cells? The column is formatted in Accounting and I need to make the number negative and skip the blank cells so they stay blank when I copy and paste the formula.

I'm a little confused by your mixture of Formatting, making a number negative and the need for a formula. What exactly are you doing with the formula? Actual examples of input and output work best, not just a "word description".

I'm thinking that a Custom Format might get you where you need to go, but I can't offer any suggestions until I know what you are trying to do.

In general, you can't "skip a blank cell" with a formula, but you can have the formula return

nothingif the cell is blank.For example, both of these formulas will return

nothing("") if A1 is empty, otherwise it will multiply the contents by 2:=IF(A1="", "", A1*2)

=IF(A1<>"", A1*2, "")

They didn't

skipA1 if it was empty, they returned the specified value, which in this case was "".

Ask Your Question

Weekly Poll

Do you think the longer-range Nissan Leaf will shake up the electric car market?

Discuss in The Lounge

Poll History