Skip to content

Car Inventory - Miles/Year formula Error #21

@ThabangZA

Description

@ThabangZA

Hi Prof,

There is an error in the formula when you use 0.5 to manage cars that are less than 1 year old.

Any number divided by 0.5 will be multiplied by 2.

Therefore the correct formula is: Miles/Year=H2/(IF(G2=0;1;G2))

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions