Excel 2000 Q - If A1 equal or less than 1000, multiply by B1, otherwise multiply by C1.

[Excel-Newbie]

Novice Excel (2000) user, what formula would I use to accomplish the following?

If A1 equal or less than 1000 value, multiply by B1, otherwise multiply by C1.


Thank you!

 

[Jonmo1]

Re: Excel 2000 Q - If A1 equal and/or less than 1000, multiply by B1, otherwise multiply by C1.

Glad to help, it was the only reasonable explaination with such a simple formula.

No idea how to help with the other issue though...sorry.