Adobe Javascript If/Else Statements with empty cells
I am trying to create a calculation sheet that only shows the result of the calculation if there is a number put in the cells above it. The values in the cells can vary from a negative numbers to positive including zero. I am trying to use this expression but it keeps throwing "SyntaxError: syntax error 26: at line 27"
____________________________________________________
var B8 = this.getField("B8").value;
var B9 = this.getField("B9").value;
var C5 = this.getField("C5").value;
var C6 = this.getField("C6").value;
var C7 = this.getField("C7").value;
var C8 = this.getField("C8").value;
var GOAL = C7+(B9-(C8-B8))+C5-C6+25;
if( C5 != "" ) {
event.value = GOAL;
}
or ( C6 != "" )
{
event.value = GOAL;
}
or ( C7 != "" )
{
event.value = GOAL;
}
or ( C8 != "" )
{
event.value = GOAL;
}
else {
event.value = " ";
}
