Thanks for the compliment.............of course it's not an "IF" statement
like the OP requested, but it seemed to be an interesting
alternative..........

Vaya con Dios,
Chuck, CABGx3


"bj" wrote in message
...
Very nice

"CLR" wrote:

=MAX((A1-B1)*3%,(B1-A1)*5%)

Vaya con Dios,
Chuck, CABGx3


"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%.