1. Math
  2. Statistics And Probability
  3. interpret the following excel statement entered in cell b4 of...

Question: interpret the following excel statement entered in cell b4 of...

Question details

Interpret the following Excel statement entered in cell B4 of a worksheet. Cell A4 contains an invoice date.
=IF((TODAY-A4)>30, “Past Due”, “OK”)

If today’s date minus the invoice date is 30 days or greater, then the text, “Past Due” should be displayed in cell B4. Otherwise, the text, “OK” should be displayed in cell B4.

If the invoice date minus today’s date is more than 30 days, then the text, “Past Due” should be displayed in cell B4. Otherwise, the text, “OK” should be displayed in cell B4.

If today’s date minus the invoice date is more than 30 days, then the text, “Past Due” should be displayed in cell B4. Otherwise, the text, “OK” should be displayed in cell B4.

If today’s date minus the invoice date is more than 30 days, then the text, “OK” should be displayed in cell B4. Otherwise, the text, “Past Due” should be displayed in cell B4.  

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution