185 Assignments 186 Write formulas that calculates the following for each scenario Name Scenario 1 Scenario 2 Scenario 3 188 189 Tif either of the conditions A3 or Bare true set the cell value to 1 otherwise to 0 both of the conditions A-C and Boo set the value to 1 otherwise 195 196 Divide A by B and if the result is an error(' /or set it to a blank