Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
-/+ forumla
ok....i have a need for a forumla that will increase and decrease as the
value in another cell goes up or down. i.e. A1 set number of 95 B1 number is 96 C1 the formula shows 1 if the number in B1 changes to 94 then C1 showns a -1 can some one help me? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
-/+ forumla
In C1 enter:
=B1-A1 -- Gary''s Student - gsnu200909 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
-/+ forumla
its a little more complicated then that. as the number goes up or down 94(B1)
i need the to formula to calulate plus or minus off a base number 95(A1) in C1 i.e. A1 is base 95 if the number in B1 is 94 than C1 goes to -1; 93 C1 goes to -2 and so forth if the number in B1 is 96 than C1 goes to 1; 97 C1 goes to 2 and so forth "Gary''s Student" wrote: In C1 enter: =B1-A1 -- Gary''s Student - gsnu200909 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
-/+ forumla
Actually Gary's Student is correct. In C1 put "=B1-A1+ works and returns the
correct number according to your examples. For something more compl;icated try an "if" formular. If number in B1 A1 use B1-A1, If number in B1 < A1 use B1-A1 (this is the same as it returns the same result if B1 is above or below A1, try it out... I.e. =if(B1=A1, B1-A1, B1-A1) Cheers, stevefromnaki "gma" wrote: its a little more complicated then that. as the number goes up or down 94(B1) i need the to formula to calulate plus or minus off a base number 95(A1) in C1 i.e. A1 is base 95 if the number in B1 is 94 than C1 goes to -1; 93 C1 goes to -2 and so forth if the number in B1 is 96 than C1 goes to 1; 97 C1 goes to 2 and so forth "Gary''s Student" wrote: In C1 enter: =B1-A1 -- Gary''s Student - gsnu200909 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
-/+ forumla
i was over thinking this....this works thanks.
"stevefromnaki" wrote: Actually Gary's Student is correct. In C1 put "=B1-A1+ works and returns the correct number according to your examples. For something more compl;icated try an "if" formular. If number in B1 A1 use B1-A1, If number in B1 < A1 use B1-A1 (this is the same as it returns the same result if B1 is above or below A1, try it out... I.e. =if(B1=A1, B1-A1, B1-A1) Cheers, stevefromnaki "gma" wrote: its a little more complicated then that. as the number goes up or down 94(B1) i need the to formula to calulate plus or minus off a base number 95(A1) in C1 i.e. A1 is base 95 if the number in B1 is 94 than C1 goes to -1; 93 C1 goes to -2 and so forth if the number in B1 is 96 than C1 goes to 1; 97 C1 goes to 2 and so forth "Gary''s Student" wrote: In C1 enter: =B1-A1 -- Gary''s Student - gsnu200909 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
what does this forumla mean? | Excel Worksheet Functions | |||
Most Used Name Forumla | Excel Worksheet Functions | |||
Help with Forumla | Excel Worksheet Functions | |||
IF Forumla help | Excel Discussion (Misc queries) | |||
Forumla | Excel Worksheet Functions |