| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Increase cell value by 1 based on another cell change
Cant figure this one out, and have around 500 records to change
eg: A1 changes from 2009 to 2010 then the value in A10 will change from 30 to 31 any help greatly appreciated thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Increase cell value by 1 based on another cell change
Hi,
in A10 enter =if(A1=2009,30,if(A1=2010,31)) "Dr. Hackenbush" wrote: Cant figure this one out, and have around 500 records to change eg: A1 changes from 2009 to 2010 then the value in A10 will change from 30 to 31 any help greatly appreciated thanks . |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Increase cell value by 1 based on another cell change
"Eduardo" wrote in message ... Hi, in A10 enter =if(A1=2009,30,if(A1=2010,31)) "Dr. Hackenbush" wrote: Cant figure this one out, and have around 500 records to change eg: A1 changes from 2009 to 2010 then the value in A10 will change from 30 to 31 any help greatly appreciated thanks Eduardo thanks for the reply but I explained wrongly, my apologies (a bad day !). What I should have said was A1 changes for example from 2009 to 2010 and whatever numbe ris in B1 increase its value by 1. the values in column B are all different random numbers. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Increase cell value by 1 based on another cell change
=if(A1=2009,B1,if(A1=2010,B1+1,""))
-- David Biddulph "Dr. Hackenbush" wrote in message ... "Eduardo" wrote in message ... Hi, in A10 enter =if(A1=2009,30,if(A1=2010,31)) "Dr. Hackenbush" wrote: Cant figure this one out, and have around 500 records to change eg: A1 changes from 2009 to 2010 then the value in A10 will change from 30 to 31 any help greatly appreciated thanks Eduardo thanks for the reply but I explained wrongly, my apologies (a bad day !). What I should have said was A1 changes for example from 2009 to 2010 and whatever numbe ris in B1 increase its value by 1. the values in column B are all different random numbers. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Increase cell value by 1 based on another cell change
Enter a $ before the number, then copy the cell.
"Dr. Hackenbush" wrote: "Eduardo" wrote in message ... Hi, in A10 enter =if(A1=2009,30,if(A1=2010,31)) "Dr. Hackenbush" wrote: Cant figure this one out, and have around 500 records to change eg: A1 changes from 2009 to 2010 then the value in A10 will change from 30 to 31 any help greatly appreciated thanks Eduardo thanks for the reply but I explained wrongly, my apologies (a bad day !). What I should have said was A1 changes for example from 2009 to 2010 and whatever numbe ris in B1 increase its value by 1. the values in column B are all different random numbers. . |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Increase cell value by 1 based on another cell change
Hi,
=if(a1=2009,B1,if(A1=2010,B1+1)) "Dr. Hackenbush" wrote: "Eduardo" wrote in message ... Hi, in A10 enter =if(A1=2009,30,if(A1=2010,31)) "Dr. Hackenbush" wrote: Cant figure this one out, and have around 500 records to change eg: A1 changes from 2009 to 2010 then the value in A10 will change from 30 to 31 any help greatly appreciated thanks Eduardo thanks for the reply but I explained wrongly, my apologies (a bad day !). What I should have said was A1 changes for example from 2009 to 2010 and whatever numbe ris in B1 increase its value by 1. the values in column B are all different random numbers. . |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Increase cell value by 1 based on another cell change
"Dr. Hackenbush" wrote in message ... Cant figure this one out, and have around 500 records to change eg: A1 changes from 2009 to 2010 then the value in A10 will change from 30 to 31 any help greatly appreciated thanks thanks for all your help , now sorted |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change background color of cell based on vlookup in cell | Excel Discussion (Misc queries) | |||
| Automatically change cell colors based on date in cell | Excel Discussion (Misc queries) | |||
| Change Text Color in one cell based upon entry in referenced cell | Excel Discussion (Misc queries) | |||
| How can I increase the value in a cell based on the changing date | Excel Worksheet Functions | |||
| How do I change cell color based upon data range within the cell? | Excel Worksheet Functions | |||
Linear Mode
