Put this in C1

=IF(A1B1,3%,5%)*(A1-B1)

and copy down

--
Regards
-
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy


"karen" wrote in message
...
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%.