If one cell says Yes, entered values should remain in the cell, otherwise it should be 0.

[olga6542]

I have an Excel spreadsheet. I know it's either circular reference or data validation problem. In the column C, I already have entered data, so the data should remain there if information in column B says Yes. If it says No it should be changed to zero.

[RaulSerg]

I think you need to effectively incorporate the Column C values in the formula then, e.g. C2 = =IF(B2="Yes",7,); D2 = =IF(B3="Yes",90,).

Regards