Drop down with valid if issue

[ReyRSL12]

I'm having a problem with valid if, with the column four I just get the error "This entry is invalid". I don't know if the problem is with the column type, I tried to change the format to number directly in my sheet, at first it worked but on the second try it doesn't work anymore. What should I do?

.

Is there any way to do the same thing with the column type REF? 

[gregdiana1]

Try change Precio from type number to type decimal?

[ReyRSL12]

I tried but it didn't work

[gregdiana1 · Accepted solution]

Precio should be an output and not input. You need to define a virtual column whose value will be Precio when all the other drop downs are selected. 

[Marc_Dillon]

Not sure if I'm following completely. Are both Estadasicas[Precios] and Lists de precios[precio sin iva] of type Decimal?

And what does this question mean?

Is there any way to do the same thing with the column type REF? 

---