| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula Help Needed
I am busy typing up a Application Form. Cell E9 contains drop-down of either
Yes or No. If user selects Yes I need text to be displayed in Cell E11 and nothing to displayed if No is selected. Tried following formula: =If(E9,"What is your Student Number?", " ") and it returned a Value Error. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula Help Needed
Try this:
=If(E9="Yes","What is your Student Number?", "") Regards, Stefi FordFiestaST150 ezt *rta: I am busy typing up a Application Form. Cell E9 contains drop-down of either Yes or No. If user selects Yes I need text to be displayed in Cell E11 and nothing to displayed if No is selected. Tried following formula: =If(E9,"What is your Student Number?", " ") and it returned a Value Error. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| IF-THEN Formula help needed | Excel Worksheet Functions | |||
| Formula needed | Excel Worksheet Functions | |||
| continuous sum formula needed | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Linear Mode
