Type the function to match the following word problem: If the rating in cell B5 is 2 or 3, return 200, otherwise return 100.

excel format

Type the function that matches the following word problem: If the value in F7 is55 and the value in G7 is 80,display 100, otherwise display zero.