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

Biology
1.2K views

This essential skill asks you to compare and contrast energy conversions in mitochondria with those in...

Medical Sciences
1.2K views

Of the following answers, which correctly describes why herd immunity against SARS-CoV-2 would result in reduced...

Physics
1.2K views

A roller coaster starts at ground level and rises up 139 m above the ground on...

Electrical Engineering
1.2K views

Summarise / compare the following diode models and contrast them against the characteristics curve of a...

Physics
1.2K views

Two large vertical and parallel metal plates having a separation of 1 cm are connected...

Physics
1.2K views

If the 16 kg ball has a velocity of 3 m s when it is...

Physics
1.2K views

4 A flux of 25mWb links with a 1500 turn coil when a current of...

Calculus
1.2K views

Divide.(-10x+7x-5)(2x-3)Write your answer in the following form: Quotient +

Accounting
1.2K views

The following accounts and balances were drawn from the records of Barker...

Accounting
1.2K views

accounting system 27. Per the Fraud Exominers Manual, what is a shell company? D. A...

Accounting
1.2K views

Inventory calculation On January 1, the finished goods inventory of the Manuel Company was $300,000during...

Accounting
1.2K views

expects to produce 1000 chrome wheels during the year. the wheels are expected tk hsr...