create an excel formula that makes this phrase "Customer has either (a) been purchasing between 1 and 3 years AND spent $450 or more last year OR (b) customer has not made a purchase in last 6 months" either true or false. thank you!!!!

Sign in File Insert Draw Page Layout Formulas Data Review View Add-ins Power Pivot Team Tell me what you want to do Share Home Cut Fill Paste Copy Sort & Find & Filter Select B 1 u . 1, Morgo & Conter . $ . % , . a conditional Format as- Cel insert Delete Format t . . der. Formatting TableStyles Styles K21 Customer Rewards Years Months Since Last Name Purchasing LY Spend Stmt 1 Stmt 2 Stmt 3 Stmt 4 4Customer 2 ustomer 3 Tne 1 200,00 200.00 $0.00 cn.nd 1-800.00 U.UD ? 5125.00 False usinmer b 9 Customer 7 0.25 False False False As.n0 cr1120$00.00 U.UD 1,100.00 275.00 n.00 4Customer 1 24 Tne False 16 Cusluner 14 the TRUTH creach of the following statements against the data 1 Customer has been purchasing for more than S years OR spent $450 or more last year Customer has either a baen punchasing batwoan 1 and3 yeas AND spent $450 ar mare t year ORI b2-customer has not msd2 purchase in Is15 months Custumer spent exsly SU lest yesr ANDhes been suustomer for above averege rumber afyears. Customer has nc: madc a purchacc In the lkst 3 months but last yearthay weanav 234average oustomer in terms of ollars spent Customer Rewards Logical Conjunctions ??- +70% 7:39 PM Type here to search 4/1/2018