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