level 1 exam activity 5

Options
Nehal1511
Nehal1511
in Modeling

added all the formulas for bonus ,car allowances,medical...but adding all car cost, medical are showing zeros

Tagged:

Best Answer

  • anand.shekhawat
    anand.shekhawat
    Answer ✓
    Options

    @Nehal1511 

    When you observe the formula that you have written, the first condition of if-else statement is false, that is why the Medical Costs are coming Zero. 

     

    ~Anand

    https://in.linkedin.com/in/anand-shekhawat-35645486

Answers

  • Nehal1511
    Nehal1511
    Options

    can you please give me little hint to where i have to make changes

  • anand.shekhawat
    anand.shekhawat
    Options

    @Nehal1511 

    Would you not mind sharing the logic that you have applied in calculating the car costs and medical costs. Also select any Employee from the drop down list to check the values and not the departments.

     

    ~Anand

    https://in.linkedin.com/in/anand-shekhawat-35645486

  • Nehal1511
    Nehal1511
    Options

    still not working after taking the employee

  • Carlos3k
    Carlos3k
    edited May 2023
    Options

    Can we get a follow up on this?

Categories