In C1 enter
=if(A1B1,(A1-B1)*.03,(B1-A1)*.05)
You should format it as %


"karen" wrote:

I need to create a formula in which if column a is bigger then b, then
subtract the two columns and multiply by 3%, or if column b is bigger then
find the difference and multiple by 5%.