I have a spreadsheet, which has a cell that is used to total the previous cells in the row. The formula that I am using is as follows, =IF(G2=1<>10,(F2*G2),IF(I2=1<>10,(H2*I2),IF(K2=1<>10,(J2*K2),IF(N2=1<>1,(M2*N2),0)))). The first 2 IF-statements [for G & I] return the value as calculated, but the last 2 [K & N]don’t. Is their a limit on how many nested IF-statements one can use?