IF function using drop down choices as logical test value

[hellcat83]

Hi

I'm trying to try a short formula for a sheet I'm working on. I want one of various calculations to be completed based on which text string is chosen from a drop down list. I've tried the standard =IF(cell="text",....) format, but it keeps defaulting to the False condition.

For example;

=IF(C1="even weighting",1,0)

is defaulting to 0, even when C1 has the correct text string chosen.

Any ideas?

Cheers

 

[AnAnalyst]

Hi,

Formula is obviously correct - is the sheet set to manual calculation?

 

[T. Valko]

Hi

I'm trying to try a short formula for a sheet I'm working on. I want one of various calculations to be completed based on which text string is chosen from a drop down list. I've tried the standard =IF(cell="text",....) format, but it keeps defaulting to the False condition.

For example;

=IF(C1="even weighting",1,0)

is defaulting to 0, even when C1 has the correct text string chosen.

Any ideas?

Cheers

What type of drop down are you using? Is it a data validation list or a combo box?

Are you sure there are no unseen whitespace characters in the drop down selection? For example, the selction might actaully be something like even weighting_ (where the underscore represents a space character). In your formula you're testing for "even weighting" compared to "even weighting_" and these do not match.