I have the following formula which returns the correct amounts, except when engineer report is selected. In this case it comes up blank. All the other selections produce the expected numbers.
IF(Type=“Inspection”,“300”,IF(Type=“Estimate”,“30”,IF(Type...