I have one column Miles and a second column Billable miles.

GLW

MILES BILLABLE MILES (RESULTS)

IF miles is > 1 miles -500, if miles < 500 "N/A"

Genevieve P.

Hi @GLW

Thank you for clarifying! We can add a statement at the beginning that says If MILES in the cell of this row is less than 500, return "N/A".

Otherwise (meaning the value is either 500 or more), then we can use your formula to subtract 500.

Try this:

=IF(Miles@row <= 500, "N/A", Miles@row - 500)

I've used @row so you can make this a Column Formula if you'd like!

Cheers,

Genevieve

Mike TV

=IF({Information provided}<{Information Required}, "Provide more info", "")

GLW

The first column MILES contains the mileage to our venue. If the mileage is over 500, we charge an additional fee for the extra miles. the extra miles will be in the second column BILLABLE MILES which is where the formula resides. the formula below works but if the mileage is 500 or less, the billable miles column shows a negative number. In lieu of the negative number, i would like it to return an N/A.

=IF(Miles1 > 1, Miles1 - 500)

Genevieve P.

Hi @GLW

Thank you for clarifying! We can add a statement at the beginning that says If MILES in the cell of this row is less than 500, return "N/A".

Otherwise (meaning the value is either 500 or more), then we can use your formula to subtract 500.

Try this:

=IF(Miles@row <= 500, "N/A", Miles@row - 500)

I've used @row so you can make this a Column Formula if you'd like!

Cheers,

Genevieve

Genevieve P.

Wonderful! I'm glad I could help.