Answered

Welcome to Westonci.ca, the Q&A platform where your questions are met with detailed answers from experienced experts. Experience the ease of finding quick and accurate answers to your questions from professionals on our platform. Get quick and reliable solutions to your questions from a community of experienced experts on our platform.

In cell a10 enter a formula using or to display true if net profit before tax in 2019 (cell b5) are greater than 750000(seven hundred, fifty thousand) or net profit before tax in 2020 (cell c5) are greater than 750000 (seven hundred, fifty thousand). use cell references where appropriate and enter the arguments exactly as described in this question.

Sagot :

MrRoyal

The OR Excel function is a function that is used to test several conditions in one statement.

The Excel formula to display true based on the conditions in cell A10 is =OR(B5>750000,C5>750000)

From the question, we have:

  • Cell B5 represents the net profit before tax in 2019
  • Cell C5 represents the net profit before tax in 2020

The syntax of the OR logical function is: =OR([conditions])

So, the Excel formula to display true based on the conditions in cell A10 is =OR(B5>750000,C5>750000)

Read more about Excel formulas at:

https://brainly.com/question/14820723

We hope this information was helpful. Feel free to return anytime for more answers to your questions and concerns. Your visit means a lot to us. Don't hesitate to return for more reliable answers to any questions you may have. Thank you for using Westonci.ca. Come back for more in-depth answers to all your queries.