Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Cell Value
Hi, New to this forum but I can already see that this was a great decision to join. Say you have a cell with the value May and I manually changed it to June is there a way of making it change other cells to a different value when I do this. Thanks peeps. Tom. -- Hopest ------------------------------------------------------------------------ Hopest's Profile: http://www.excelforum.com/member.php...o&userid=23765 View this thread: http://www.excelforum.com/showthread...hreadid=374144 |
#2
|
|||
|
|||
Hopest Welcome to the forum. The answer to your question is Yes For example: if you want a value in cell C5 to be 10 if A1 is "May" but you want it to be 20 if A1 is "June" then the formula you put in C% would be =IF(A1="May",10,IF(A1="June",20,"")) Provide details as to what exactly you want Excel to do and you'll get your question answered in specific detail. -- Cutter ------------------------------------------------------------------------ Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848 View this thread: http://www.excelforum.com/showthread...hreadid=374144 |
#3
|
|||
|
|||
Absolutely it's possible. IMO a spreadsheet would be a pretty useless piece of software if I couldn't somehow link the value in A2 to the value entered in A1. From the simplest formula A2=A1 which makes A2 simply a reflection of the value in A1 to complex engineering formula to text functions to lookup functions and on and on. It really isn't a question of, "is it possible." Rather you need to determine what the relationship between the value in A2 and the data entered in A1 and make the spreadsheet do it. -- MrShorty ------------------------------------------------------------------------ MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181 View this thread: http://www.excelforum.com/showthread...hreadid=374144 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AutoFIll -by dragging the bottom-right corner of the cell | Excel Discussion (Misc queries) | |||
how to create a variable column in cell reference | Excel Worksheet Functions | |||
Can a Formula in Cell X modify Cell Y? | Excel Discussion (Misc queries) | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |