# What is the correct formular?

#### crazyacd1

##### New Member
Im trying to create an excel sheet, if you put a value of up to and including 6 in lets say A1 i want a value in B2 to be 10, also if the value is more than 6 and less than or equal to 10 in A1 I need the value to read 16 in B2 and so on. what forular would i use?
I can get it with the IF formular but it gives me the answer of 6 and 10 in the required cell.

### Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
It does rather depend upon what "and so on" means. Perhaps something like the following?
=IF(A1<3,6,0)+(INT((A1-7)/4)+1)*6+10

Replies
17
Views
466
Replies
3
Views
183
Replies
32
Views
638
Replies
3
Views
284
Replies
2
Views
188

1,203,071
Messages
6,053,375
Members
444,658
Latest member
lhollingsworth

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