Formulas showing as correct but not working

[Lesley11356]

I use a very very basic formula to calculate a percentage of one column into
another. I've not changed anything but today when opening the document, the
formula does not work. I've tried reentering it but still does not work.
Has anyone any ideas on what might be the cause.

 

[Nayab]

I use a very very basic formula to calculate a percentage of one column into
another.  I've not changed anything but today when opening the document, the
formula does not work.  I've tried reentering it but still does not work.  
Has anyone any ideas on what might be the cause.  

check the values in evaluate formula. It will show you where it is
facing an issue.

 

[David Biddulph]

"... does not work" is not much of a fault description.
If you want help, why not tell us what formula you are using, what values
you are feeding into it, what result you got, and what result you exptected?

 

[lintugi]

Hi there,

After a few attempt i'm still couldn't solve my formula editing :-

When i'm using scientific calculator for the following equation:-

Cos -1 (1810/(3.142*(914.4-16.76) =

The answer that i get

=50.07

And when i press shift 'degree' i get = 50.40 degree

When i'm trying into excel by using the following equation:-


'=Sin(1-)(1810/(3.142*(914.4-16.76)))'

I couldn't get the answer as same as i'm using scientific calculator
can somebody help me corrected my equation on excel? I'm try t
understand math equuation on 'help' but the result still the same.

Please help me, because the equation is important to my studie