Constructive pivot table showing the cancel agenda versus. Carrier and type type versus usage in the company survey data

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 C 3 is not 9 , the number 4 will be assigned bo cell G7. 1) =[F(G7=9)(G7=7)=0R(G7=4) 2) =|F(G7=7)=THEN(C3=9)=OR(C3=4) 3) = IF (C3=9)(C3=7)=0R(C3=4) 4) =F(C3=9,7,4)