=IF(I21>3000,I22*10%,IF(I21,>3000<50000,I22*8%,IF( I21>50000,I22*)))



hello, could you please help, i need to
IF I21 is less than 3000 it needs to be times by 10 %
IF I21 is equal to 3000-50 000 it needs to be times by 8 %
IF I21 is greater than 50 000 it needs to be times by 6%

above is my attempt

thank you and sorry

Hi

Your profile has Office 2016, use the IFS function if you have.

=IFS(A1<3000,I22*0.1,A1<50000,I22*0.08,A1>=50000,I 22*0.06)

Alternatively you can use the LOOKUP or VLOOKUP functions.

Thanks you are awesome !