I need to find a way to quantify or score the two numbers.

[plockerman]

I try not to ask redundant questions so hopefully, this hasn't been answered before, I haven't seen anything that speaks to this.

Column A has a value.
Column B has a value.

I need to find a way to quantify or score the two numbers.

eg.

If A2 increases in value and B2 increases in value, I want C2 to reflect a "score" or value that indicates it.

Where I am having a problem is that if B2 value decreases it is better, so it isn't a "sum" situation.

So, if A2 decreases in value or stays the same and B2 decreases then I want to see a better "score" in C2.
If A2 increases or B2 increases, then I should see a poorer score in C2.

So basically if both values decrease up to a limit that would show a better score or result and if either rises it should then show a quantifiable value reflecting the amount of rise.

So hard to illustrate.

Sorry for the confusion, thanks in advance.

[shg]

For example, ...?

[plockerman]

Here's another stab at it.

There is a target value for each cell/column. "A" value "target" is 50 for example and "B" value "target" is 20, then that would produce a result of 100 in "C".
So as the values in both A and B columns change, it would reflect so in column C.

[shg]

Please show an example with several rows and desired results. Ideally, in a workbook; the forum rules explain how to attach one.

[plockerman]

Let me try and mock up a small illustration.

[plockerman]

The values in column C are arbitrary except for C6

Except for the value in C6, the other values in C are unknown.

As the value in "A" moves closer to the value in A6 it adds to or increases the value in "C"

While at the same time,

As the value in "B" moves closer to the value in B6 it adds to or increases the value in "C"

When both "A" and "C" cells reach their optimum value it should produce a value that reflects that (for example 100)


Capture.JPG

[shg]

	a	b	c	d
1	75	50	45	c1: =100 - abs(sum(a1:b1) - sum(a$6:b$6))
2	70	50	50
3	65	40	65
4	60	35	75
5	60	30	80
6	50	20	100

[plockerman]

Wow, that's amazing.
This should work fine.
Thank you!

[shg]

You're welcome.