Maths problem is driving my crazy?

im trying to devise a scoring mechanism for a trend analyses.

ive come up with the following.

there are 2 inputs

x = is the overal position.

for ease ive capped x between -2.5 and 2.5

y is the trend movement direction and size

i use the following formula to devise a rating between 0 and 100. based on x.

100-(50 + (-)50 - sin ( x * 2 / pi) * 50)

my problem is the 100- is optional. it should only be done if x and y are not both positive, or both negative.

cant get the damn thing right in excel. anyone have any ideas?

1 Answer

Relevance
  • 6 years ago

    In Excel pseudocode, I suppose it would be something like

    If (xy < , 100, 0) - (50 + (-)50 - sin ( x * 2 / pi) * 50)

Still have questions? Get your answers by asking now.