Hello,

I am stuck on this question for an Excel formula.

Question: If the total dollar amount of the orders for the customers used UPS Trade Direct is larger than the other two method. Otherwise, put yes into M column. Otherwise, put no into the column.

I thought the formula would be =IF(C2>D2>E2, "yes","no") - it keeps returning "yes" for everything.

CustName	Sales Total	Sales total Using UPS Trade Direcct	Sales Total Using Frieght	Sales Total Using Express Critical	UPS Trade Direcct has the largest sales total
Bigmart	$ 240,875.02	$ 159,427.90	$ 9,664.80	$ 71,782.32
Cool Threads	$ 201,014.46	$ 127,206.17	$ -	$ 73,808.29
Corner Runner	$ 130,385.72	$ 98,414.72	$ -	$ 31,971.00
Cross Country Mart	$ 151,660.00	$ 90,830.80	$ 40,192.85	$ 20,636.35
CustName	$ -	$ -	$ -	$ -

Thank you!