i created a list and can't figure out how to make a certain value in another cell when a certain text is choosen, any advice would help
use the IF function
IF(value in list column="specific text",if true expression,if false expression)
to fully answer this question may require more details
Regards
The search for people who can answer your question continues for as long as needed - until you find the answer you were looking for.
When an answer is posted by someone who was invited (byYedda or by yourself) to answer your question, their answer is marked with a yellow "invited by Yedda".
To be invited to answer other people's questions in your areas of knowledge and interest, be sure to list your favorite topics:
» My Settings › My Topics.
Of course, the more helpful your answers are, the more likely you are to be invited to future questions...
markpx hit the nail on the head. Excel's 'IF' function is extremely useful. Here's a page with more details on the syntax:
http://www.techonthenet.com/excel/formulas/if.php
Got an answer for v9p? Would you like to comment on the posted answers, or vote for the one which you think is the best?
Sign up for a free account, or sign in (if you're already a member).
Other people asked questions on similar topics, check out the answers they received:
