Answer :
Final answer:
The function =IF(C4>15000,5000,0) in Excel returns the value 5000 if the condition C4>15000 is true. If the condition is not true, it returns 0. Thus, the 'value if true' is 5000.
Explanation:
The function =IF(C4>15000,5000,0) is a conditional function in Excel. If the condition C4>15000 is true, then the function will return the value 5000. This would be the value if true. However, if the condition is not true (that is, if C4 is not greater than 15000), then the function will return the value 0. Therefore, the correct answer to your question is b. 5000.
Learn more about Excel Functions here:
https://brainly.com/question/34762060
#SPJ11
