# Multiple "If" and "And" Statements

#### Paul Gronowski

##### New Member
I have a form that uses check boxes to trigger the formula for the reimbursement amount. There are two categories for reimbursement up to \$40 max and up to \$80 max. C7 is the cell the shows the total bill to be expensed.

((If box one is checked (\$40 max), and if (C7>40,then 40,if not C7). or (if box 2 is selected (\$80 max), if (C7>80,then 80,if not C7))

I linked cells F8 and F9 to be True or False. If check box one is selected, then TRUE if not false. If check box 2 is selected, then TRUE, if not false.

I was thinking something like this, using the "if" and the "and" statements - but obviously it does not work. if(and(F8="True",C7>40.00),40.00,C7),if(and(f9="true",C7>80.00),80.00,c7))

any help would be appreciated including a VBA code.

### Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December
Try:
=f(and(F8="True",C7>40.00),40.00,if(and(f9="true",C7>80.00),80.00,c7))

It is just listing the amount in C7 no matter what box i check.

That worked, the "TRUE" did not need the "". Thanks for your help.

You don't actually need the =TRUE part at all.

=if(and(F8,C7>40),40,if(and(f9,C7>80),80,c7))

=MIN(C7, IF(F8,40,IF(F9,80,C7)))

Replies
4
Views
469
Replies
0
Views
300
Replies
1
Views
293
Replies
13
Views
516
Replies
7
Views
289

1,196,483
Messages
6,015,461
Members
441,898
Latest member
kofafa

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