Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. i need to adjust the formula so there is no n/a. i

I need to adjust the formula so there is no N/A. I noticed my error...

70.2K

Verified Solution

Question

Accounting

I need to adjust the formula so there is no N/A. I noticed my error is when there are more than 2 guests it displays N/A. How can I adjust the

=IF formula when there are 3, 4, 5, or 6 guests. Please.

image

image

AutoSave CH HR Yecica_Lara_Assignment1 - Excel Yeci Lara YL File Home Insert Draw Page Layout Formulas Data Review View Add-ins Help JMP Analytic Solver Share = 22 General Arial 11 AA BIUR A Insert EX Delete Data Mining O Search 27 O 3 Sort & Find & Ideas Filter Select Editing Ideas Paste Sensitivity Format Conditional Format as Cell Formatting Table Styles Styles Clipboard Font 5 Alignment Nurnber Cells Sensitivity K3 : fe =IF(H3

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Q

Find the area of the figure Sides meet at right angles 4 in 5 in...

Geometry
Q

4. (4pts) A $10,000 par value 10-year bond with 8% annual coupons is bought at a...

Finance
Q

Given the following information for a Electronics company, find its WACC. Assume the company’s tax rate...

Finance
Q

LINEAR ALGEBRA The main topic studied is linear regression using matrices. The main idea being that you...

Statistics
Q

Discuss the role of melanocytes in determining skin and hair color

Medical Sciences
Q

What would the effect be if each of the different sub-units of E.coli DNA polymerases were...

Biology
Q

The leadership traits,skills and behavior of Nelson Mandela in his book Long Walk to Freedom ,and...

General Management
Q

16- ill...

Accounting
Q

john is contemplating several financial transactions. he has sought your advice for his various queries....

Accounting
Q

Weisman Company issued $1,000,000, 10-year bonds and agreed to make annual sinking fund deposits of...

Accounting
Q

Capricio Enterprises distributes a single product whose selling price is $19 and whose variable expense...

Accounting
Q

1, Which of the following statements is true? A) Under variable costing, direct...

Accounting