Hi Sherry

if(and(a13000,a1<5000),a1*1.2,a1)

HTH
Regards From Brazil
Marcelo

"Sherry" escreveu:

I think I need to use an "IF" function for the following but don't know how
to write if statements. Can anybody help?

If Cell A is between 3,000 and 5,000 then multiply by 20%

Thanks!!