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?
- Pauley MorphLv 76 years ago
In Excel pseudocode, I suppose it would be something like
If (xy < , 100, 0) - (50 + (-)50 - sin ( x * 2 / pi) * 50)