If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Please help with formula
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. |
#2
|
|||
|
|||
Please help with formula
"exntluser" wrote:
C2 displays difference between A1 & B2 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 ----- "exntluser" wrote in 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. |
#3
|
|||
|
|||
Please help with formula
In C2 enter the formula =$A$1-B2 and drag it down
"exntluser" wrote: 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. . |
#4
|
|||
|
|||
Please help with formula
Many Thanks Joe
"Joe User" joeu2004 wrote in message ... "exntluser" wrote: C2 displays difference between A1 & B2 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 ----- "exntluser" wrote in 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. |
Thread Tools | |
Display Modes | |
|
|