Question

using an IF function with a nested IF function what will be the the formula If...

  1. using an IF function with a nested IF function what will be the the formula
    1. If the employee declines dental insurance, then the Dental cost is $0
    2. If the employee is single the dental cost is $25
    3. If the employee is married the dental cost is $35. JUST WANT THE FORMULA
0 0
Add a comment Improve this question Transcribed image text
Answer #1

main()

{

char d_insuarance;

char marital_status;

int dental_cost;

printf("want to do dental insuarance y or n ");

scanf("%c",&d_insuarance);

printf("enter your marital status s for single m for married");

scanf("%c",&marital_status);

if(d_insuarance =='y')

{   

if( marital_status= ='s')

{

dental_cost=25;

else if(marital_status=='m')

dental_cost=35;

else

{

printf("you did not entered single or married");

break;

}

}

else

dental_cost=0;

}

Add a comment
Know the answer?
Add Answer to:
using an IF function with a nested IF function what will be the the formula If...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 5. In cell B18, create a formula 18, create a formula using nested IF functions and...

    5. In cell B18, create a formula 18, create a formula using nested IF functions and VLOOKUP functions to determine to do with the returns. Use the lookup table in the Return Data worksheet. Refer to Figure 8-46 for some hints on how to create the formula. gure 8-46 Formula for return resolution If the value in B16 is: Destroy The lookup_ value is: B14 The col The table index_num array is: is: Dept_Returns 2 The range lookup is: FALSE...

  • In cell B25, calculate fixed costs by use a nested IF function to display the Low...

    In cell B25, calculate fixed costs by use a nested IF function to display the Low Risk Administrative Cost if the value in cell B18 is Low, to display the High Risk Administrative Cost if the value in cell B18 is High or display the Standard Risk Administrative Cost. Format as Accounting with 0 decimal places. Bean Healthcare Beantacob - Excel Pile fx Home Insert Page Layout Formulas Data Review View Help 2 A @ @ Auto Sum Recently Financial...

  • Using python, create a program using nested loops to write a function called substring(s,b) that returns...

    Using python, create a program using nested loops to write a function called substring(s,b) that returns True or False depending on whether or not b is a substring of s. For example: String: "Diamond" Substring: "mond" The code will then state that this is true and "mond" is a substring of "Diamond". Example of what the program should output: Enter string: Tree Enter substring: Tre Yes, 'Tre' is a substring of 'Tree' Limitation: This program cannot use "find()" and "in"...

  • Programming in C: Using a nested for loop create the pattern below. Prompt the user for...

    Programming in C: Using a nested for loop create the pattern below. Prompt the user for the height (number of rows) and width (number of characters per line) for pattern A. You may use any number for height and width, just as long as the basic pattern is preserved. Call a function to print the pattern. This function receives the height and width as inputs (parameters) but does not return a value. Make use of an if structure to instruct...

  • Question 22: Which formula includes a nested function? Answer:   A. =SUM(H3*A7)+AVERAGE(B2:B6) B. =MAX(A5, A9, D12:D15) C....

    Question 22: Which formula includes a nested function? Answer:   A. =SUM(H3*A7)+AVERAGE(B2:B6) B. =MAX(A5, A9, D12:D15) C. =ROUND(MIN(A2:A7)+E1) D. =(A6+B9-C4)*L1

  • Lab 5-2 Nested Loops 2. Summation Of Numbers (using Nested While Loops) Part A: The program...

    Lab 5-2 Nested Loops 2. Summation Of Numbers (using Nested While Loops) Part A: The program will calculate and display the total of all numbers up to a specific number (entered by the user). Only positive numbers are allowed. Part B: User-controlled loop Part A Input Validation loop Part A: Summation loop Examples: When 5 is entered the program will calculate the total as 1+2+...+5 and display 15. When 2 is enterered the program will calculate the total as 1+2...

  • Write a MATLAB script, using either a single or nested for-loop, that will print the factorials...

    Write a MATLAB script, using either a single or nested for-loop, that will print the factorials for the numbers between 1 and 100 (inclusive). The factorial of n (n!) is the product of the positive integers less than or equal to n. For example: 3! = 3 * 2 * 1. For this question you cannot use the built-in MATLAB factorial function, but you can use other MATLAB functions if you wish. MATLAB code!MATLAB code!MATLAB code!MATLAB code!

  • I am having difficulty writing the Nested function. The formula  I used was =IF(B2<20,"LOW",IF(B2<40,"AVERAGE",IF(B2<100,"HIGH","PRIME"))). All I got...

    I am having difficulty writing the Nested function. The formula  I used was =IF(B2<20,"LOW",IF(B2<40,"AVERAGE",IF(B2<100,"HIGH","PRIME"))). All I got was Prime for everything. need help with a nested function in excel. 8. In the "Order Quality Nested" column, create a Nested IF function to rank the customer sales by the average sales per order. If the average sales amount per order is less than $20, rank as Low, $20 to less than $40 "Average," $40 to less than $100 as "High," and over...

  • Consider the function f(x) := v/x= x1/2. 6. (a) Give the Taylor polynomial P(x) of degree 5 about a1 of this function (b) Give the nested representation of the polynomial Qs()Ps((t)) where t -1 (...

    Consider the function f(x) := v/x= x1/2. 6. (a) Give the Taylor polynomial P(x) of degree 5 about a1 of this function (b) Give the nested representation of the polynomial Qs()Ps((t)) where t -1 ((t)+1). (c) Using the nested multiplication method (also called Horner's algorithm), compute the approximation Ps (1.2) to V (give at least 12 significant digits of P(1.2)) (d) Without using the exact value of 12, compute by hand an upper bound on the absolute error V1.2 A(1.21...

  • Please explain nested for loops in Javascript like I'm 5 years old. No matter how many...

    Please explain nested for loops in Javascript like I'm 5 years old. No matter how many examples I look at of nested for loops, I can't really understand what they're doing, or when I'd actually want to use them. Every time I look at an example of someone using them, I figure I can just call on the items in a single loop. I can't find many concrete examples where I'd say ''ahh, I definitely need to nest for loops...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT