# Formula

#### BenNV

##### Board Regular
Hello!

I am trying to find a formula which will do the following.

Length Width Size
10 6 ?

Say in Length, I have 10. The user will input the width, in this case 6. Then in Size I would like excel to divide the width by 2, then minus and add this to the length. So, Size would be 7 and 13. I would like it to look like:

Length Width Size
10 6 7/13

### Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
Hi,

Try:

=A1-B1/2&"/"&B1/2+A1

Assume your values are A1:B1 and you need a numerical result

=((-B1/2)+A1)/((B1/2)+A1)

format C1 as a custom format of # ?/13

Hope this helps

Try this,
Book1
ABCD
1LengthWidthSize
21067/13
Sheet1

HTH
Bob

Replies
1
Views
165
Replies
3
Views
102
Replies
1
Views
977
Replies
36
Views
835
Replies
0
Views
189

1,203,355
Messages
6,054,920
Members
444,759
Latest member
TeckTeck

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