0
$\begingroup$

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

$\endgroup$
2
  • 2
    $\begingroup$ SIN function expects an argument in radians, so even in formula 2 it should still be SIN(RADIANS(a)). $\endgroup$
    – peterwhy
    Commented Feb 6, 2021 at 1:32
  • $\begingroup$ @peterwhy, Super answer. Please make it an answer and I will accept it. Thank you. $\endgroup$
    – NoChance
    Commented Feb 6, 2021 at 1:43

1 Answer 1

1
$\begingroup$

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

$\endgroup$
1
  • $\begingroup$ I appreciate your help. $\endgroup$
    – NoChance
    Commented Feb 6, 2021 at 1:46

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .