I want to format a cell to use this formula =A2*B2+D2+H2+K2+P2+R2+V2+J2+N2 if the value in Q2 is less than 11, I want the cell to choose this formula =A2*B2+D2+H2+K2+P2+S2+V2+J2+N2 if the value of Q2 is >=11 and <=20, I want the cell to choose this formula =A2*B2+D2+H2+K2+P2+T2+V2+J2+N2 if the value of Q2 is >=21 and <=30, I want the cell to choose this formula =A2*B2+D2+H2+K2+P2+U2+V2+J2+N2 if the value of Q2 is >=31 and <=40
Bookmarks