Formula

[BenNV]

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

 

[fairwinds]

Hi,

Try:

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

 

[WillR]

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

 

[staticbob]

Try this,

Book1
	A	B	C	D
1	Length	Width	Size
2	10	6	7/13
Sheet1

HTH
Bob