formula help

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

Sheeloo

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

Macro to select and delete levels of a document 2
Work Budget Salary vs Real Time Salary 0
Newbie Help - IF Yes No Function 0
Drop down list control value in vba 2
Use TODAY() function as the criteria in a SUMIF formula 1
Transfer data between two tables 3
LISTNUM + Mail Merge + INCLUDETEXT : Referencing Paragraph # Can't get to work 0
Cumulative formula for word table 0

Top