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

Excel-Newbie

New Member
Joined
Oct 30, 2013
Messages
10
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!
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)
Re: Excel 2000 Q - If A1 equal and/or less than 1000, multiply by B1, otherwise multiply by C1.

Thanks, tried it but did not work, also, please keep in mind its equal and/or less than.

Thanks again.

Welcome to the board..

Try
=A1*IF(A1<1000,B1,C1)
 
Upvote 0
Re: Excel 2000 Q - If A1 equal and/or less than 1000, multiply by B1, otherwise multiply by C1.

That should have been
=A1*IF(A1<=1000,B1,C1)

But if you had say 500 in A1, it would still multiply by A1*B1 without the = in the formula.
If it didn't then your number in A1 isn't really a number, it's a "Number stored as text"

Try
=A1*IF(A1+0<=1000,B1,C1)
 
Upvote 0
Re: Excel 2000 Q - If A1 equal and/or less than 1000, multiply by B1, otherwise multiply by C1.

Thanks Jonmo1, but I am afraid it did not work. Here is what I am trying to accomplish.

From Cell C22, IF C12 < AND/OR 1000, C12*B22, otherwise 0.00. I would then use the same formula on C23, C26, and C27.

Here is the spreadsheet screenshot:

Example-1.jpg


Thanks!

I find Excel so complicated!
 
Upvote 0
Re: Excel 2000 Q - If A1 equal and/or less than 1000, multiply by B1, otherwise multiply by C1.

From Cell C22, IF C12 < AND/OR 1000, C12*B22, otherwise 0.00.

Now its 'Otherwise 0'? before it was 'Otherwise C1'

going with this most recent description of what you want...
Plus wanting to use the same formula in muliple cells..

Try
=IF(C$12<=1000,C$12*B22,0)
 
Upvote 0
Re: Excel 2000 Q - If A1 equal and/or less than 1000, multiply by B1, otherwise multiply by C1.

I'm really sorry about that. I thought I was simplifying things with my initial post. But when I realize how complicated this is, I thought it would be best to be more detailed.

I copied your formula and pasted it on C22, but Excel reports a formula error and highlights "1000,C$12" portion of the formula in the formula bar. I must be doing something wrong. Does it make a difference what version of Excel I'm using (Version 2000)?

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

You may need to change the , to a ;
It's a regional settings difference.

Probably the same reason the 1st suggestion didn't work..
 
Upvote 0
Re: Excel 2000 Q - If A1 equal and/or less than 1000, multiply by B1, otherwise multiply by C1.

Thanks, but it still not working. However, its now only highlighting the "1000" portion of the formula in the formula bar -so I guess progress is being made?

Does it make a difference what version of Excel I'm using (Version 2000)?

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

You changed BOTH , to ; ?
Sorry I wasn't that specific in last post..

=IF(C$12<=1000;C$12*B22;0)
 
Upvote 0

Forum statistics

Threads
1,213,544
Messages
6,114,249
Members
448,556
Latest member
peterhess2002

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top