How do you get the breadth of a question?

[Guest]

example the area is 36cm2 and the length 9cm what's the breadth

 

[N Harkawat]

if your result is shown as it is that is 36cm2 instead of the number 36
cell A1 = 36cm2
B1 = 9cm
on cell C1 type this
=--SUBSTITUTE(A1,"cm2","")/--SUBSTITUTE(B1,"cm","")

Now this formula will only work if the cells have cm2 and cm respectively
if they are different like sqft etc.. then you will need a different formula

However if its plain 36 and 9 then its simply
=a1/b1

However if you

 

[Niek Otten]

36/9 (=4)

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel