Circle Sector Area Calculation - I am getting wrong answer

78 Views Asked by At

I am trying to calculate the area of a circle segment using MS-Excel. The radius value is stored in variable "rr", the angle is stored in variable "a".

There are 2 equivalent formulas, depending on whether the angle is in digress or radians, that should yield the same results, but in my case, I am getting different results.

Formula 1 gives:$57.345$ - I think this is the correct one...

Formula 2 gives:$303.025$

Where are my mistake in Formula $2$? Thank you.

enter image description here

1

There are 1 best solutions below

1
On BEST ANSWER

SIN function expects an argument in radians, so even in formula 2 it should still be SIN(RADIANS(a)).