Thread: Formula Needed
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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!!!!!