formula help

  • Thread starter Thread starter MHS
  • Start date Start date
M

MHS

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.
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IF formula 5
formula IF > AND < 2
HELP!! New to Excel. Need complex SUMIF. 0
Formula Error 6
Formula 12
Count total balance using two numbers 5
Help with a formula 2
greater les than formula 3

Back
Top