If statement is true then display dropdown menu

[Padgoi]

I have a bowling spreadsheet. I'm trying to code it in such a way that if there are a certain number of entries in my contest, then I automatically get entered. However, if the number of entries is not met, then I can still be entered, but a dropdown would display where I could choose whether to enter myself or not. So here it is a little more detailed:

- Cell B3 is the number of entries in the contest. It is a simply countif function that counts the number of entries based on column C. If Column C has the word "Yes," it counts it.
- Cell B27 is my name.
- Cell C27 is the column which specifies whether I'm in the contest or not.

What I want is this - if the number of entries in cell B3 is greater than 29, I want cell C27 to auto-populate with the word "Yes" (which is easy enough to do with a simple IF Statement).
Here's the hard part - if the number of entries in cell B3 is less than 30, I want a dropdown to appear in cell C27 to show whether I want to manually enter myself if there are less than the required number of entries to auto-enter me.

Can this be done? Can anyone assist with this please? Thanks in advance.

[Richard Buttrey]

Hi,

Using only those two cells I don't see how you can do this without a macro. You're asking for the cell to contain both a formula and a manual entry on different occasions. However why not use a third cell where you choose to indicate whether to enter yourself. Suppose that extra cell is say B4 and that it contains a dropdown with Yes,No choice, then your formula in C27 would be

Please Login or Register  to view this content.