How can I get the IF command to leave False portion alone and complete the formula

J Smith

This is to track mileage being run on a vehicle as invoices come in. If the number is negative I want it to say "Mileage not Recorded" But currently it will leave blank all the cells with positive numbers that I need to be there. How can I get this to do nothing for the false portion?

=IF(Mileage@row - (INDEX({Donated Mileage}, MATCH([V#]@row, {V#}))) < 0, "Mileage not Recorded")

Matt Lynn-PCG

@J Smith So you're saying if it's less than zero, show "mileage not recorded" but if it's not, show the mileage? You're statement doesn't have a true and a false value so it has no choice but to assume to do nothing.

Try:

=IF(Mileage@row - (INDEX({Donated Mileage}, MATCH([V#]@row, {V#}))) < 0, "Mileage not Recorded",Mileage@row - (INDEX({Donated Mileage}, MATCH([V#]@row, {V#}))))

J Smith

@Matt Lynn-PCG That worked!! Thank you so much. I see what your saying now. It has to know what to do if false it cannot simply do nothing. Makes sense.

Thank you again. Take care!