Rather than nest "if"s use the "ifs" formula =IFS(A1<1000,A1*0.2,A1<2000,A1*0.15,A1>=2000,A1*0.1) Easier to read as the arguments to the function are in pairs, logical test, then the value.
My answers
Rather than nest "if"s use the "ifs" formula
=IFS(A1<1000,A1*0.2,A1<2000,A1*0.15,A1>=2000,A1*0.1)
Easier to read as the arguments to the function are in pairs, logical test, then the value.