# SUMIF, COUNTIF?!?

#### TKC100

##### New Member
I know that there is no doubt a simple solution to this problem but it's got me stumped. Fact is I don't even know what to call it. SUMIF, COUNTIF, IF......
Entering a formula from cell J10
If the valve of A9 is equal to or less than 12 enter 12
If the valve of A9 is equal to of greater than 12 enter that number
I have a contract in which I pay facility rental for a min. of 12 students
A9 is not the entry cell but rather it is a number brought forward from another worksheet.
Any help on this problem will be greatly appreciated.
Thanks!

### Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)
Welcome to MrExcel Board!

=MAX(12,A9)

Hope that helps!

darn, that is a lot better than what I had in mind

=IF(C17<=12,12,C17)

You the man Tazguy!
Posted this message and kinda never expected a reply.
I'm not sure what the logic behind the MAX is but it works
Thanks!

The MAX function returns the largest value in a set of values.

Replies
4
Views
425
Replies
1
Views
203
Replies
3
Views
205
Replies
3
Views
604
Replies
1
Views
701

1,203,242
Messages
6,054,350
Members
444,718
Latest member
r0nster

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