How to set valid if rule based on another field

[Daisy_Ramirez]

I’m trying to run the following Valid IF but I’m getting the error below:

If the type field is ROUTE COMPLETE, then the Fuel Cost field is valid if its >0 but less than 1000. The field could otherwise be 0 or >0 but less than 1000.

[Suvrutt_Gurjar]

You may wish to try below

OR(
AND([Type]=ROUTE_COMPLETE, [_THIS]>0, [_THIS]<1000),

AND([_THIS]>=0, [_THIS]<1000)
)

[Daisy_Ramirez]

Thank you Suvrutt, this worked perfectly!

[Steve]

There is no => operator, which renders this expression invalid.

[Suvrutt_Gurjar]

Good catch @Steve.

[Daisy_Ramirez]

Got it. Very helpful. Thanks Steve

[Lucinda_Mason]

Just checking, => is invalid but >= works, correct?

I use >= all over the place in my app.

[Daisy_Ramirez]

Yes you’re right. Greater/Less than symbol before equal symbol is the correct format;)

[Steve]

Lucinda_Mason:

but >= works, correct?

Yes.