Number Font Alignment Styles URITY WARNING External Data Connections have been disabled Enable Content X v & M N O P D E F - G H K Num of Price Trans Boxes Price per ans # Date Type City Received per box box Instructions 12645 2-Apr-20 Red Delicious Okanagan 25 #VALUE! $ 20.00 Your goal is, using IF and AND find the price per box for each transaction in the yellow 18723 2-Apr-20 Gala Kelowna 34 $ 20.00 19726 2-Apr-20 Fuji Okanagan 38 $ 20.00 highlighted cells. The pricing is decided as follows: 18789 2-Apr-20 Granny Smith Fraser Valley 12 $ 20.00 19544 3-Apr-20 Honey Crisp 19 $ 25.00 Red Delicious apples from Kelowna - $30 a box. Langley 19545 3-Apr-20 Red Delicious Kooteney 81 $ 20.00 Honey Crisp from Langley are $25 a box. 19467 4-Apr-20 Red Delicious Kelowna 14 $ 30,00 All other types are $20 a box. 19468 4-Apr-20 Ambrosia Fraser Valley 36 $ 20.00 19469 4-Apr-20 Granny Smith Langley $ 20.00 All formulas must be able to be copied down that column without further editing 19470 4.Apr-20 Honey Crisp Kooteney $ 20.00 19471 5-Apr-20 Red Delicious Kelowna $ 30.00 Results are given in Red. 19472 5-Apr-20 Red Delicious Okanagan $ 20.00 19473 8-May-20 Red Delicious Kelowna $ 30.00 19474 8-May-20 Gala Okanagan NENSNSNENEN $ 20.00 19475 8 May 20 Fuji Kooteney $ 20.00 19476 9-May 20 Granny Smith Kelowna $ 20.00 19477 9 May-20 Honey Crisp Langley $ 25.00 19478 11-May 20 Red Delicious Kooteney $ 20.00 19479 11-May 20 Ambrosia Kelowna $ 20.00 01 02 03 Q4 05 4 5:41 PM