John Baird
Coatesville, Pennsylvanie, États-Unis
Mike Yearwood
Toronto, Ontario, Canada
Information générale
Catégorie:
Codage, syntaxe et commandes
>Hi John
>
>I'm neither an economist nor a mathematician. Exposure to business and accounting systems may be enough. Assuming the margin is the difference between the cost and the sales as a percentage of the sales price, doesn't this work?
>
>abs(tnPrice-tnCost)/tnPrice*100
>
>HTH
I've already tried that. What is happening is:
Assuming 2.00 cost and 8.00 price, the formula calculates the margin at 75%.
Assuming 2.00 price and 8.00 cost, the formula says its -300%.
Shouldn't that be -75% in the second or am I not understanding the process or the math?
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement