Making a value 1/-1 if column C is Yes/No and blank if blank

[Ckunze]

I am working on building a database for inventorying items, I want the spreadsheet to update the value for tracking purposes when someone enters the value yes or no for incoming or outgoing. I cannot for the life of me figure out the If statement I need to get for it to work the way I want it.

I want if column C="Yes", Column B=1, if C="No" then Column B=-1, and if it is blank it stays blank

[#2]

The formula you're asking for, @Ckunze , is =IF(C3="yes",1,IF(C3="no",-1,""))

FWIW, if you were to have the formula yield TRUE or FALSE, false is treated as 0.