flag if > 6000

Samuel Dowdy Jr.

=IF([Current Mileage]@row - [Service Mileage / Hrs]@row, >6000, 1)

What am I doing wrong? Iwant to flag if the difference is greater than 6,000

Mark Cronk

Hi @Samuel Dowdy Jr ,

Try this:

=IF(([Current Mileage]@row - [Service Mileage / Hrs]@row) >6000, 1,0)

The syntax for an IF statement is: IF( logical_expression, value_if_true,  [ value_if_false ])

Work?

Mark

Mark Cronk

Hi @Samuel Dowdy Jr ,

Try this:

=IF(([Current Mileage]@row - [Service Mileage / Hrs]@row) >6000, 1,0)

The syntax for an IF statement is: IF( logical_expression, value_if_true,  [ value_if_false ])

Work?

Mark