IFF Formula not working in ms project

Kioko Kyalo 1 Reputation point
2021-01-29T15:37:17.243+00:00

This is my formula, where could I have gone wrong? It's multiplying every number by 10

IIf([Name]="Half Made Meat 1",[Number1]*2,IIf([Name]="Half Made Meat 2",[Number1]*3,IIf([Name]="Half Made Meat 3",[Number1]*4,[Number1]*10)))

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
4,053 questions
0 comments No comments
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.