how do I make a formula to skip blank cells?

Microsoft Microsoft excel 2007 (pc)
June 2, 2010 at 06:34:06
Specs: Windows XP
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.

See More: how do I make a formula to skip blank cells?

Report •

June 2, 2010 at 08:24:29
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 nothing if 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 skip A1 if it was empty, they returned the specified value, which in this case was "".

Report •
Related Solutions

Ask Question