Microsoft Excel: Formula computing wrong information

Krystal Swed 0 Reputation points
2025-05-13T17:14:53.4033333+00:00

I am creating a Food cost workbook to be able to price out ingredient and have a sheet that you select the ingredient item, how much you are putting in the portion and it projects the cost for that amount you are inputting.

I have already checked the results and formula on where the amounts are being pulled from and those are correct but when I input this formula into the recipe cost sheet to cost an entire recipe menu item it is not pulling the correct information.Screenshot 2025-05-13 at 9.39.19 AM

Screenshot 2025-05-13 at 9.38.44 AM

Screenshot 2025-05-13 at 9.38.08 AM

Microsoft 365 and Office | Excel | For business | Windows
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.