How to the text/word of a cell in excel 2010

Closed
MNayak Posts 1 Registration date Monday July 22, 2013 Status Member Last seen July 22, 2013 - Jul 22, 2013 at 05:05 AM
 Blocked Profile - Jul 22, 2013 at 01:43 PM
Hi,

I am working on creating an excel spreadsheet in which I want a series of names to be outputted if the condition of another cell is valid.

For example:-

If the user selects "August" from a drop down menu then the cell should output the name of a person mentioned in another sheet in one of the cells.

Though I want a names in each individual cell but for now if anyone could help me with the use of the basic formula needed for my problem.


Thanks.


Rgds,
Mandy

1 reply

Blocked Profile
Jul 22, 2013 at 01:43 PM
Good afternoon,
I hope this helps

=if(logical test, true, false)


=if(a1="somevalue","do this because it is true","cell a1 does not contain somevalue so it is false")

What? Me, help?
0