Date Reporting

[kevinc1981]

I have two cell lets say mileage that if the value is over20 then it gets reported on the next cell. I am not sure how to write this formula so it only reports mileage over 20

 

[saboh12617]

Hello,

If you have an array of mileages in cells A3:A12, you can filter them like so

=FILTER(A3:A12, A3:A12>20)

Which will extract only the ones (strictly) above 20.

 

[Fluff]

Hi & welcome to MrExcel.

Could you post some sample data, as it's not that clear what you have & need.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[kevinc1981]

Hello,

If you have an array of mileages in cells A3:A12, you can filter them like so

=FILTER(A3:A12, A3:A12>20)

Which will extract only the ones (strictly) above 20.

Ok so H7 is start Miles and I7 is ending mileage and I want to report greater than 20 on J7 what would that look like. It appears to be a subtraction Formula?

 

[saboh12617]

Ok so H7 is start Miles and I7 is ending mileage and I want to report greater than 20 on J7 what would that look like. It appears to be a subtraction Formula?

Ho well in this case it is a different problem. Maybe you should have a look at @Fluff's advice to make your question very clear.

From what i understand, to hide differences below 20, you can put this formula in J7

=IF(I7-H7>20, I7-H7, "")

Using if, you can adapt the result.

 

[kevinc1981]

Hello,

If you have an array of mileages in cells A3:A12, you can filter them like so

=FILTER(A3:A12, A3:A12>20)

Which will extract only the ones (strictly) above 20.

Ok so H7 is start Miles and I7 is ending mileage and I want to report greater than 20 on J7 what would that look like. It appears to be a subtraction Formula?

DATE	TIME	DESCRIPTION	PURPOSE	FROM	TO	ODOMETER START	ODOMETER FINISH	MILEAGE over 19
								0.0

So this is the excel sheet Odometer start and End the mileage over 19 column is the Odometer ending -minus mileage beginning reports in next column only if over 19

 

[Fluff]

Maybe

=MAX(0,I7-H7-19)