Function

Please Login or Register  to view this content.

The two quotes in succession refer to a blank or empty cell/value. The "?" is looking for a question mark as the value in a cell. The formula, broken down section by section says:

=IF(AND($F11="",$G11=""),"",

...If F11 and G11 are both blank, then show blank (nothing) in this cell.

IF(AND($F11="?",$G11="?"),"",

...If F11 and G11 both contain question marks, then show blank in this cell.

IF(AND($F11=0,$G11=0),0,

...If F11 and G11 both contain 0, then show 0 in this cell.

IF(OR($F11>0,$G11>0),(E11*F11)+(E11*G11/2)))))

...If F11 or G11 is greater than 0, then add the product of E11 and F11 with the product of E11 and G11/2.

Hopefully that makes sense.