Avatar

Level 4

The formula that you have used isn't achieving the same end result that I was getting with my 'If' statement.

Your formula

Cell3 + Cell4 + Cell5 + Cell6 + Cell7 + Cell8

My formula

if (Table1.HeaderRow2.Cell3.rawValue == null) {

this.rawValue = Table1.Row1.Cell3.rawValue + Table1.Row1.Cell4.rawValue + Table1.Row1.Cell5.rawValue + Table1.Row1.Cell6.rawValue + Table1.Row1.Cell7.rawValue + Table1.Row1.Cell8.rawValue;

}

else{

this.rawValue = Table1.Row1.Cell3.rawValue*Table1.HeaderRow2.Cell3.rawValue + Table1.Row1.Cell4.rawValue*Table1.HeaderRow2.Cell4.rawValue + Table1.Row1.Cell5.rawValue*Table1.HeaderRow2.Cell5.rawValue + Table1.Row1.Cell6.rawValue*Table1.HeaderRow2.Cell6.rawValue + Table1.Row1.Cell7.rawValue*Table1.HeaderRow2.Cell7.rawValue + Table1.Row1.Cell8.rawValue*Table1.HeaderRow2.Cell8.rawValue;

}