Excel formulas are expressions used to perform computation.
The corrected version of the formula is =IF(B9>500,IF(F9="Yes",B9*B20,B9*B21),"Empty")
The formula that returns an error is given as:
=IF(B9>500,IF(F9="Yes",B9*B20,B9*B21)"Empty")
The format of an IF function is:
=IF(condition, "value if true", "value if false")
In the given formula, we have:
Condition: B9 > 500
Value if true: IF(F9="Yes",B9*B20,B9*B21)
Value if false: Empty
The above means that, there is a missing comma between the values if true and false
Hence, the corrected version of the formula is =IF(B9>500,IF(F9="Yes",B9*B20,B9*B21),"Empty")
Read more about Excel formulas at:
https://brainly.com/question/14820723
