Formula Needed
 

I am in need of a formula that will calculate a months worth of salary. I am
currently using =(annual pay/12)x1

This is not calculating correctly.
Thank you very much!!!!!

Formula Needed
 

Hi,

This formula would work with the annual salary in A1

=A1/12

Note there'e no need to multiply by 1 but if you needed to for some reason
it would be

=(A1/12)*1

Mike

"KimC" wrote:

I am in need of a formula that will calculate a months worth of salary. I am
currently using =(annual pay/12)x1

This is not calculating correctly.
Thank you very much!!!!!

Formula Needed
 

Use Absolute references like

$A$1:$C$10

If this post helps click Yes
---------------
Jacob Skaria


"KimC" wrote:

I am in need of a formula that will calculate a months worth of salary. I am
currently using =(annual pay/12)x1

This is not calculating correctly.
Thank you very much!!!!!

Formula Needed
 

Sorry the below is a wrong post
--
If this post helps click Yes
---------------
Jacob Skaria


"Jacob Skaria" wrote:

Use Absolute references like

$A$1:$C$10

If this post helps click Yes
---------------
Jacob Skaria


"KimC" wrote:

I am in need of a formula that will calculate a months worth of salary. I am
currently using =(annual pay/12)x1

This is not calculating correctly.
Thank you very much!!!!!

Formula Needed
 

what type of wrong answer you are getting and in which form you want it.

"KimC" wrote:

I am in need of a formula that will calculate a months worth of salary. I am
currently using =(annual pay/12)x1

This is not calculating correctly.
Thank you very much!!!!!