Ignoring minus figures in excel after subtraction

  tims31 21:21 09 Oct 08
Locked

Please help with this formula problem, its driving me nuts.

I am trying to do a formula in excel 2007 which subtracts this months total mileage from last months and puts the result in another cell. In the Oct cell the figure is obviously a minus as no figure is added yet so that shows as a minus which I have managed to ignore but if I put the data into a chart it shows a bar of however much the minus figure is.

Is there a way of ignoring this minus figure in the unused cells so it doesn't show on the bar chart?

The formula for the subtraction is =SUM(B12-B11)
I have tried =SUMIF(B12-B11,">0") but this comes up with an error.

Please help!!!!!!

Thanks in advance

  VoG II 21:54 09 Oct 08

Try

=IF(OR(B11="",B12=""),"",B12-B11)

  JPJBozo 13:19 10 Oct 08

If I remember right if you use the IF function you have to supply an alternative answer such as =IF(B12-B11>0,1,0), in your case after >0, the numbers would be what you want.

  tims31 22:50 10 Oct 08

Sorry guys, but neither of those worked. It worked out the mileage correctly but the negative value still shows on the chart. After much playing around though I worked out that the axis can be moved to the zero value to ignore any minus figures.

Thanks for you help though.

Tims31

This thread is now locked and can not be replied to.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

VFX Oscar nominees 2017: Discover how the visual effects were created

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…