flag if > 6000
=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
-
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
-
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.
Help Article Resources
Categories
Check out the Formula Handbook template!