# 9/4

1. ### Converting fractions to decimals

I have data which looks like this - 9/4 JF 6/4 F 5/2 F 2/1 F etc etc Using this formula I can convert these to - 9/4 6/4 5/2 2/1 ' =IFERROR(LEFT(T136,FIND("/",T136)+1),T136) But what I'm really looking for is - 2.25 1.5 2.5 2 I'm happy to use an extra column to achieve my goal but if it can...
2. ### How do I update an Incrementing Range of Cells using Data Entry?

What formula can I write to enter a value in to the "Input Cell" (D4), and: Successively update a cell in the Cell Range (A6:G6) In the example below, the 9/4 entry updated to the 4.73. The next entry will update the 9/5 cell and leave all previous entries unchanged. Thank-you very much...
3. ### Replacing If with Max

Hello Guys , As I heard that Max formula is the quicker formula , I was thinking I would like to speed up my workbook. This the sample. Sheet1 <tbody> 9/1 9/2 9/3 9/4 A B 1 1 A Y 1 </tbody> Sheet2 <tbody> P 1st Date 2nd Date Status B 9/1 9/4 A Y 9/2 9/3 B 9/1 A B...

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