Explore. Ask. Answer.

or Explore Discussions

flag if > 6000

Samuel Dowdy JrSamuel Dowdy Jr ✭✭✭✭✭
in Formulas and Functions
12/31/20
Accepted

=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

Best Answer

  • Mark CronkMark Cronk ✭✭✭✭✭
    Accepted Answer

    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


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Answers

  • Mark CronkMark Cronk ✭✭✭✭✭
    Accepted Answer

    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


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Sign In or Register to comment.