? B C D 38 Company Total Liabilities Total Assets Debt Ratio 39 Jones Co

Finance Nov 24, 2020

? B C D 38 Company Total Liabilities Total Assets Debt Ratio 39 Jones Co. 42560 40 Examole 995400 41 Doobry & Cludge 65200 83500 0.781 Some of these companies have not filed all their financial information. The formula to calculate Debt Ratio only where all the information is available and otherwise avoid an error in column D would be: Select one: a. =IF(AND(NOT(BLANK(B39),BLANK(C39)),B39/C39,"") b. =IF(OR(ISBLANK(B39).ISBLANK(C39)),"",B39/C39) c. =IF(AND(ISBLANK(B39),ISBLANK(C39))."",B39/C39) d. =IF(OR(NOT((BLANK(B39),BLANK(C39)), B39/C39,"") age

Expert Solution

Ans:

b. =IF(OR(ISBLANK(B39),ISBLANK(C39))"",B39/C39)

Remaining 3 are wrong formula.

In Excel there is no BLANK function that used in option a&d.So option a& d is wrong.

In here we must use OR function instead of AND function , So option c is also wrong option.

Archived Solution

Unlocked Solution

You have full access to this solution. To save a copy with all formatting and attachments, use the button below.

Already a member? Sign In

Important Note: This solution is from our archive and has been purchased by others. Submitting it as-is may trigger plagiarism detection. Use it for reference only.

For ready-to-submit work, please order a fresh solution below.

Or get 100% fresh solution

Get Custom Quote