If target cell is A1, multiplication factor in B1 and C1, number to check in
D1 then enter this in E1
=IF(D1=A1,D1*B1,D1*C1)


"MHS" wrote:

If my target cell is less than a specific number I want to multiply it by a
certain rate and if it's greater than this specific number I want to multiply
it by a different rate.
If someone could write down a sample formula I think I can figure it out.
thanks.