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

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

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