The formula above will sense data in A5 sheet 1 and if true multiply it by cell D5 sheet 1 and then by cell A9 in sheet 2. It only works if the cell is blank. There are other “IS….” commands but I couldn’t see one that handles empty cells and Nulls. Also note, if A5 is blank the equation returns a “0”.
Hope this helps