Hide error value in spreadsheet?

[ululator]

I have a simple spreadsheet to track my mileage. It has a column calculating miles driven since the last fill-up. The “miles driven” formula is simply =B4-B3 (current odometer reading minus previous odometer reading.)

Until I input my current odometer reading, the following row’s “miles driven” column displays the previous odometer reading as negative value. Example:
ROW 2: Current Odometer Reading = 53,000
ROW 3: Current Odometer Reading = 53,200; Miles Driven = 200
ROW 4: Current Odometer Reading = blank (awaiting input); Miles Driven displays as -53,200
ROW 5: Current Odometer Reading = blank (awaiting input); Miles Driven = blank

How do I hide that negative value & just display a blank cell?

I know how to keep other types of error values from displaying (zero values, #DIV0!, etc.)
But I can’t figure out how to hide this single pesky negative! Any ideas?

[ConneXionLost]

Use this as your miles driven formula:

Please Login or Register  to view this content.

Cheers,

[judgeh59]

here are a few

this checks to see if the A2 is greater than zero so you won't get a #DIV/0 error

Please Login or Register  to view this content.

Please Login or Register  to view this content.

these are very generic answers for your dataset....HTH

[ululator]

Thank you both! I appreciate your clear-cut, simple solutions - exactly what I needed!