If nested statement issues

[winter12]

It worked before and now my entire table is broken cause it is dependent on the outcome of this formula.

So I have many sheets with the formula below, however each one is unique with its own cell value. The information
it pulls from sheet 1 "Table of Contents" is a drop down list, data validation, with values: low, medium, high. The
formula works EXCEPT when the cell value is High. I have also tried switching the first statement to medium and it
works. It just seems to overlook high.

=IF('Table of Contents'!$B$4="high",0.5,IF('Table of Contents'!$B$4="medium",0.2,0))

Thanks in advance

[Olly]

Can you attach a workbook please?

[ragulduy]

Is it an issue with case sensitivtiy - you have High in your post but high in the formula? maybe:
=IF(UPPER('Table of Contents'!$B$4)="HIGH",0.5,IF(UPPER('Table of Contents'!$B$4)="MEDIUM",0.2,0))

[winter12]

Can you attach a workbook please?

Sorry, I cannot, its confidential!

[Olly]

It's almost impossible to debug, then. Check your formula points at the correct cell, and that no errant spaces or punctuation have been introduced. Start a fresh formula which simply checks the value of your data validation list entry.

[winter12]

Is it an issue with case sensitivtiy - you have High in your post but high in the formula? maybe:
=IF(UPPER('Table of Contents'!$B$4)="HIGH",0.5,IF(UPPER('Table of Contents'!$B$4)="MEDIUM",0.2,0))

I tried playing around with the case sensitivity. No matter what medium is picked up and high is not.

[winter12]

It's almost impossible to debug, then. Check your formula points at the correct cell, and that no errant spaces or punctuation have been introduced. Start a fresh formula which simply checks the value of your data validation list entry.

OK, I started fresh in a new workbook. Problem was with data validation. The referenced data had a space on the end of High. So much time wasted on a space.

[Olly]

Glad it was a simple fix