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
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
What do you mean "exclude"?
If F12 = 5 and G12 = -7 what do you want the result to be?
Audere est facere
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.
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,"")
That worked, fantastic. Thanks so much.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks