Excel formula - blank cell calculation for info on hand

September 26, 2012 at 20:27:52
Specs: Windows Vista
March June Sept Dec mileage
increase
60630 61630 62630 64630 4000
59503 60503 61503 61503 2000
54529 54529 56425 57420 2891
48481 48481 50481 0 -48481
50229 51229 0 0 -50229
48029 48029 0 0 -48029

I subtracted D3-A3 for my mileage increase, but this doesn't work when blank cells are involved. How can i have it calculate only the info i currently have to date?


See More: Excel formula - blank cell calculation for info on hand

Report •

#1
September 27, 2012 at 05:20:18
First, a posting tip...

Please click on the blue line at the end of this post and read the instructions on how to post example data in this forum. Thanks!

How about using the MAX function?

=MAX(B3:D3)-A3

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question