Below is a spreadsheet of purchase orders for a computer hardware re 1 Purchase Orders CD Item Item Cast per A/P Terms Order Supplier Description Cost Quantity Order (Months) No. Order Size Kinphics 4 Rex Technologies Card $89 35 $3115 20 AL123 Large 5 Rex Technologies Monitor Rex Technologies Keyboard Rex Technologies Speakers Max's Wavetech HD Cables Max's Wavetech Processor 10 Max's Wavetech Hard disk $150 15 52250 25 AL234 Small 515 40 $600 15 AL345 Large $15 20 $300 25 AL456 Small $5 10 $50 25 KO876 Small 5278 27 $6950 30 KO765 Large $120 18 $2160 20 KO654 Small 12 Supplier Order Size Item Cost 13 Rex Technologies Large 14 Max's Wavetech 15 If cell G7 contains the function it states that if the value in cell C3 is 9, the number 7 will be assigned to cell G7; if the value in cell C3 is not 9, the number 4 will be assigned to cell G7. 1)=IF(G7-9)(G7=7)=OR(G7=4) 2)=IF(G7-7)=THEN(C3-9)=OR(C3=4) 3)=IF(C3-9)(C3-7)=OR(C3=4) 4)=IF(C3=9,7.4)