cell values

[cernst]

Hello - I am working on a spreadsheet for call monitoring for work and need a value to populate into another cell

example:
If C12 = Yes then D12 = 5
If C12 = No then D12 = -5
IF C12 = N/A then D12 = 5

if this possible?

[Barbara Excel]

try this
=IF(C12="yes",D12=5,IF(C12="no",D12=-5,IF(C12="n/a",D12=5,""))

hope that helps
Barbara Excel

[cernst]

Thanks so much for the assistance for some reason the value is not sticking would you mind looking at the spreadsheet? If you could that would be great under verifcation name the dashes when you click --- (cell d12) has yes, no, n/a if yes is selected i want 5 to fill in cell E12 no -5 to filter to E12 or N/A to filter 5 into E12. I did not know how to put a drop down box and think because I used the validation list that it wont formulate correctly I have been playing with this all night and once I removed the validation list with yes, no n/a it appears to work. In addition if there is already 1 no with -5 is it possible to have it with another No =0?

I really appreciate any assistance you can give

thanks