# Min Help

#### gebo84

##### Board Regular
Hi,

I have a formula in cell T4 (=R4/38) this is calculating and average Hourly Rate for staff wages.

But I need a formula to stop the Cell calculating below £6.50.

So, the lowest calculation it can return is £6.50, with now restrictions on how high it can go

thanks
G

### Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.

#### gebo84

##### Board Regular
=MAX(6.5,(R16/38))

I've gone with this formula, which seems to be working - please let me know if it's wrong though

#### Joe4

Try this:
=MAX(R4/38,6.5)

Edit: I see you posted while I was reading and replying. Yep, that is the way to go!

Replies
1
Views
239
Replies
10
Views
630
Replies
10
Views
3K
Replies
1
Views
208
Replies
5
Views
380

1,195,600
Messages
6,010,651
Members
441,558
Latest member
lambierules

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