Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to decrease cell1 value if i increase cell2 value & visaversa
How would i get the value of one cell to increase or decrease as i alter the
value of another cell? example: cell 1 has a value of '3'..if cell 2 has a value of '1' then i want cell 1 to change its value to '2'...if cell 2 has a value of '0' then cell 1 will remain at value '3' if anyone can help..please mail me...many thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to decrease cell1 value if i increase cell2 value & visaversa
Try this: Enter
=IF(E2=1,2,IF(E2=0,3,3)) in cell 2, E2 being cell 1. Regards, Stefi €˛apmelectronic€¯ ezt Ć*rta: How would i get the value of one cell to increase or decrease as i alter the value of another cell? example: cell 1 has a value of '3'..if cell 2 has a value of '1' then i want cell 1 to change its value to '2'...if cell 2 has a value of '0' then cell 1 will remain at value '3' if anyone can help..please mail me...many thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to decrease cell1 value if i increase cell2 value & visave
Hi Stefi,
Many thanks for the help...although it is on the right track, its not quite doing it. with the formula you have supplied if cell 1 is anything but '1' then cell 2 remains at '3' if cell 1 is '1' then cell 2 is '2'.. I've tried to modify this formula myself so that i could say it worked.. but i know nothing about IF commands. But like i said...definately on the right track - thanks again for your efforts Paul "Stefi" wrote: Try this: Enter =IF(E2=1,2,IF(E2=0,3,3)) in cell 2, E2 being cell 1. Regards, Stefi €˛apmelectronic€¯ ezt Ć*rta: How would i get the value of one cell to increase or decrease as i alter the value of another cell? example: cell 1 has a value of '3'..if cell 2 has a value of '1' then i want cell 1 to change its value to '2'...if cell 2 has a value of '0' then cell 1 will remain at value '3' if anyone can help..please mail me...many thanks! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to decrease cell1 value if i increase cell2 value & visave
Just to clarify what i need it to do, please see below what each cell should show at given values cell1 '3' cell2 '0' cell1 '2' cell2 '1' cell1 '1' cell2 '2' cell1 '0' cell2 '3' cell one being the input cell many thanks "Stefi" wrote: Try this: Enter =IF(E2=1,2,IF(E2=0,3,3)) in cell 2, E2 being cell 1. Regards, Stefi €˛apmelectronic€¯ ezt Ć*rta: How would i get the value of one cell to increase or decrease as i alter the value of another cell? example: cell 1 has a value of '3'..if cell 2 has a value of '1' then i want cell 1 to change its value to '2'...if cell 2 has a value of '0' then cell 1 will remain at value '3' if anyone can help..please mail me...many thanks! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to decrease cell1 value if i increase cell2 value & visave
Clear question, clear answer ...
=ABS(E2-3) stefi €˛apmelectronic€¯ ezt Ć*rta: Just to clarify what i need it to do, please see below what each cell should show at given values cell1 '3' cell2 '0' cell1 '2' cell2 '1' cell1 '1' cell2 '2' cell1 '0' cell2 '3' cell one being the input cell many thanks "Stefi" wrote: Try this: Enter =IF(E2=1,2,IF(E2=0,3,3)) in cell 2, E2 being cell 1. Regards, Stefi €˛apmelectronic€¯ ezt Ć*rta: How would i get the value of one cell to increase or decrease as i alter the value of another cell? example: cell 1 has a value of '3'..if cell 2 has a value of '1' then i want cell 1 to change its value to '2'...if cell 2 has a value of '0' then cell 1 will remain at value '3' if anyone can help..please mail me...many thanks! |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to decrease cell1 value if i increase cell2 value & visave
Cracked it!!!
Many, many thanks!!! Paul "Stefi" wrote: Clear question, clear answer ... =ABS(E2-3) stefi €˛apmelectronic€¯ ezt Ć*rta: Just to clarify what i need it to do, please see below what each cell should show at given values cell1 '3' cell2 '0' cell1 '2' cell2 '1' cell1 '1' cell2 '2' cell1 '0' cell2 '3' cell one being the input cell many thanks "Stefi" wrote: Try this: Enter =IF(E2=1,2,IF(E2=0,3,3)) in cell 2, E2 being cell 1. Regards, Stefi €˛apmelectronic€¯ ezt Ć*rta: How would i get the value of one cell to increase or decrease as i alter the value of another cell? example: cell 1 has a value of '3'..if cell 2 has a value of '1' then i want cell 1 to change its value to '2'...if cell 2 has a value of '0' then cell 1 will remain at value '3' if anyone can help..please mail me...many thanks! |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to decrease cell1 value if i increase cell2 value & visave
You are welcome! Thanks for the feedback!
Stefi €˛apmelectronic€¯ ezt Ć*rta: Cracked it!!! Many, many thanks!!! Paul "Stefi" wrote: Clear question, clear answer ... =ABS(E2-3) stefi €˛apmelectronic€¯ ezt Ć*rta: Just to clarify what i need it to do, please see below what each cell should show at given values cell1 '3' cell2 '0' cell1 '2' cell2 '1' cell1 '1' cell2 '2' cell1 '0' cell2 '3' cell one being the input cell many thanks "Stefi" wrote: Try this: Enter =IF(E2=1,2,IF(E2=0,3,3)) in cell 2, E2 being cell 1. Regards, Stefi €˛apmelectronic€¯ ezt Ć*rta: How would i get the value of one cell to increase or decrease as i alter the value of another cell? example: cell 1 has a value of '3'..if cell 2 has a value of '1' then i want cell 1 to change its value to '2'...if cell 2 has a value of '0' then cell 1 will remain at value '3' if anyone can help..please mail me...many thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Percentage Increase/Decrease | Excel Discussion (Misc queries) | |||
Cell1 must be blank before cell2 can except date | Excel Discussion (Misc queries) | |||
% of increase or decrease | Excel Discussion (Misc queries) | |||
How do I set a cell that can increase but never decrease? | Excel Discussion (Misc queries) | |||
Is there a function, if cell1=Text then cell2=#? Excel 03 | Excel Worksheet Functions |