# Formula

#### Joey172

##### New Member
I am trying to set up a formula for a column of cells but I don't know how
Here are the criteria
If the rate is 0.003515 and weight multiplied by rate < 11.50, then the charge is 11.50
If false, the rate is weight multiplied by rate

I can get that part but there are more criteria
If rate IS NOT 0.003515 and weight multiplied by rate < 15.00, then teh charge is 15.00
If false, the rate is weight multiplied by rate

I hope this isn't too confusing...Can anyone tell me how to set up such a formula? Thanks.

Excel User

### Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

#### Brian from Maui

##### MrExcel MVP
Joey172 said:
I am trying to set up a formula for a column of cells but I don't know how
Here are the criteria
If the rate is 0.003515 and weight multiplied by rate < 11.50, then the charge is 11.50
If false, the rate is weight multiplied by rate

I can get that part but there are more criteria
If rate IS NOT 0.003515 and weight multiplied by rate < 15.00, then teh charge is 15.00
If false, the rate is weight multiplied by rate

I hope this isn't too confusing...Can anyone tell me how to set up such a formula? Thanks.

Excel User

How many more criterias?

L

#### Legacy 21301

##### Guest
=IF(AND(Rate=0.003515,Rate*Weight<11.5),11.5,IF(AND(Rate<>0.003515,Rate*Weight<15),15,Rate*Weight))

#### Joey172

##### New Member
Hey thanks...that <> was the trick.....I didn't know how to put an unequal sign

#### tactps

##### Well-known Member

Assume cell A1 contains the rate, and column B contains the weight.

In cell C1:
=IF(AND(\$A\$1=0.003515,\$A\$1*\$B1<11.5),11.5,IF(AND(\$A\$1<>0.003515,\$A\$1*\$B1<15),15,\$A\$1*\$B1))

Then copy down.

#### berg891832

##### Well-known Member
Try this although untested. May get you on the right track nonetheless

if(and(rate=0.003515,weight*rate<11.50),11.50,if(and(rate<>0.003515,weight*rate<15),15,weight*rate))

#### Joey172

##### New Member
how about that same formula, but adding a roundup function?? thanks. nesting is so weird

#### berg891832

##### Well-known Member
=ROUNDUP(IF(AND(A1=0.003515,B1*A1<11.5),11.5,IF(AND(A1<>0.003515,B1*A1<15),15,B1*A1)),2)

berg

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

1,168,037
Messages
5,856,966
Members
431,841
Latest member
jaybeem

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

### Which adblocker are you using?

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

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