Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
you don't need to construct an IF() statement. You can just put $A1="Miles" in the condition box of the CF dialog. You can use any expression that evaluates to True or False.