Report thread as spam

I would like a formula that would give me the following answer:

If
A1 displays 10.5
B2 displays 10.3
B3 displays 10.7
B4 displays 10.1

Then
C2 displays difference between A1 & B2
C3 displays difference between A1 & B3
C4 displays difference between A1 & B4
etc etc

I hope this makes sense.....

Thank You in advance for any replies.

This question was started by exntluser 4 years ago

C3 displays difference between A1 & B3
C4 displays difference between A1 & B4
etc etc

Ostensibly, put the following formula into C2 and copy down through C4 and
beyond:

=$A$1 - B2

However, you did not explain what "difference" you want: A1-B2 or B2-A1.
Make adjustments to the above as needed. If you always want a non-negative
"difference", then use the following formula:

=ABS($A$1 - B2)

Finally, you note that A1 "displays" 10.5 and B2 "displays" 10.3. Perhaps
you are aware that the **actual** value might be different from the
displayed value.

Just to be sure, if you want the "difference" to be based on the
**displayed** value, and the displayed value is rounded to 1 decimal place
due to formatting, it would be prudent to use the following formula:

=ROUND($A$1,1) - ROUND(B2,1)

Even better, use ROUND in the formulas for A1, B2 etc, unless they contain
constants.

----- original message -----

I would like a formula that would give me the following answer:

If
A1 displays 10.5
B2 displays 10.3
B3 displays 10.7
B4 displays 10.1

Then
C2 displays difference between A1 & B2
C3 displays difference between A1 & B3
C4 displays difference between A1 & B4
etc etc

I hope this makes sense.....

Thank You in advance for any replies.

This response was posted by Joe User 4 years ago

In C2 enter the formula =$A$1-B2 and drag it down

I would like a formula that would give me the following answer:

If
A1 displays 10.5
B2 displays 10.3
B3 displays 10.7
B4 displays 10.1

Then
C2 displays difference between A1 & B2
C3 displays difference between A1 & B3
C4 displays difference between A1 & B4
etc etc

I hope this makes sense.....

Thank You in advance for any replies.

.

This response was posted by PJ 4 years ago

Many Thanks Joe

C3 displays difference between A1 & B3
C4 displays difference between A1 & B4
etc etc

Ostensibly, put the following formula into C2 and copy down through C4 and
beyond:

=$A$1 - B2

However, you did not explain what "difference" you want: A1-B2 or B2-A1.
Make adjustments to the above as needed. If you always want a
non-negative "difference", then use the following formula:

=ABS($A$1 - B2)

Finally, you note that A1 "displays" 10.5 and B2 "displays" 10.3. Perhaps
you are aware that the **actual** value might be different from the
displayed value.

Just to be sure, if you want the "difference" to be based on the
**displayed** value, and the displayed value is rounded to 1 decimal place
due to formatting, it would be prudent to use the following formula:

=ROUND($A$1,1) - ROUND(B2,1)

Even better, use ROUND in the formulas for A1, B2 etc, unless they contain
constants.

----- original message -----

I would like a formula that would give me the following answer:

If
A1 displays 10.5
B2 displays 10.3
B3 displays 10.7
B4 displays 10.1

Then
C2 displays difference between A1 & B2
C3 displays difference between A1 & B3
C4 displays difference between A1 & B4
etc etc

I hope this makes sense.....

Thank You in advance for any replies.

This response was posted by exntluser 4 years ago

### Other excel threads