Formula to exclude negative numbers and blanks

**Hackett** · 01-12-2015, 04:39 PM

I have a formula...
=IF(ISNUMBER(F12),F12-G12,"")

but I want it to exclude negative numbers in Column G, do you have any suggestions?

Thanks
Jim

**daddylonglegs** · 01-12-2015, 04:45 PM

What do you mean "exclude"?

If F12 = 5 and G12 = -7 what do you want the result to be?

**Hackett** · 01-12-2015, 04:59 PM

Its for a column of numbers for a stacked bar chart, I want it to leave out any numbers that are negative or blank. The first 18 numbers are positive and the last 3 are negative (in column G). Column F has some blanks so I want them left out also. It's for a hi/low/close type of chart that they used to use MicroCharts for, trouble is the president of the company died and the company just closed so I need an Excel chart to replace it.

**daddylonglegs** · 01-12-2015, 06:17 PM

This formula will only return a result if both cells contain numbers and G12 >= 0

=IF(AND(COUNT(F12,G12)=2,G12>0),F12-G12,"")

**Hackett** · 01-13-2015, 08:18 AM

That worked, fantastic. Thanks so much.

Formula to exclude negative numbers and blanks

LinkBack

Thread Tools

Rate This Thread

Display

Formula to exclude negative numbers and blanks

Re: Formula to exclude negative numbers and blanks

Re: Formula to exclude negative numbers and blanks

Re: Formula to exclude negative numbers and blanks

Re: Formula to exclude negative numbers and blanks

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Having two date return number but exclude negative numbers

[SOLVED] VBA to Sort Data and exclude the negative numbers with respect to time during averaging

Exclude blanks from formula

Formula to make product of two negative numbers negative

[SOLVED] Excel Formula - Add column of numbers but ignore negative numbers

Bookmarks

Bookmarks

Posting Permissions