I HAVE 2 CELLS WITH DIFFERENT "IF" STATEMENTS
Cell Q73 reads
=IF(L73=300000,"3000",IF(L73=270000,"2700",IF(L7 3=240000,"2400",IF(L73=200000,"2000","0"))))
Cell Q74 reads
IF(L74=200000,"3000",IF(L74=170,000,"2700",IF(L7 4=140000,"2400",IF(L74)=100000,"2100","0"))))
Cell F66 has the number 1
Cell F67 has the number 2
I am trying to write a formula that says IF F66 is a "1" use the formula in
cell Q73 and if F66 is a "2" use the formula in Q74. I keep getting a 0 for
the answer so I figure it is not reading the formula because I have tested
the formula and it works. Any help is appreciated.