Hello,
I am trying to work out an average of 2 cells however the 2 cells have a IF formula which is the selected from another cell.
so on my page I have a dropdown option on 2 cells F17 & F18 (options = 3, 2, 1, N/A)
Cells K17 & K18 have the formula =IF(F17=3, "100%",IF(F17=2, "66%",IF(F17=1...