# If Statements

#### sarahlee

##### New Member
Okay I am a student at Creighton and have never really dealt with if statements before and I am lost. I have to figure out if people get a bonus. But if they sell a certain number of house they get the bonus or if they sell a certain amount of money in houses they get the bonus. But if they do both they get a bigger bonus. Can anyone help me figure out where to start?

### Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.
Use if statement. Can you give a specific example like what amount, etc.?

Okay there are two types of houses if they sell a total of 12 houses they get a bonus of 25000, or if they sell over 2,200,000 worth in both houses they get the 25,000 bonus but if they sell over 12 houses and more than 2,200,000 worth of houses they get 40,000 in a bonus

I assume you mean 2.2M or over then the formula is
Assuming the no. of houses is in cell a1 and amount sold is in cell b1 then
the formula is
=IF(AND(A1>=12,B1>=2200000),40000,IF(A1>=12,25000,IF(B1>=2200000,25000,0)))

you are awesome. thank you very much

Replies
1
Views
170
Replies
1
Views
214
Replies
3
Views
243
Replies
6
Views
98
Replies
1
Views
182

### Forum statistics

1,203,728
Messages
6,057,021
Members
444,902
Latest member
ExerciseInFutility

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