How to assign values

**maiykl** · 03-27-2024, 10:27 PM

Hello,

I am not new to Excel but it has been quite a while, therefore I am out of shape. I want to build a calorie calculator + create dieting plans, but I need your help.

1. I want to have a list of different products, such a rice, chicken etc. and assign those to their respective calories and
2. with the help of that list create dieting plans.

So when I defined that rice should only calculated in 100 grams and bread in pcs., when I type in bread in 1 column and the quantitiy in another column, it should give the total calories. Sounds pretty easy imo. But I dont get how to assign
1. the calories and 2. the type of quanitity (Pcs or 100 grams) to the products. Is there a formula that lets me define Rice == Pieces, Rice == 180 kcal.? I defined rice with the help of variables, but when it comes to the calculation, I couldnt define the type of quantity for the products. I just need to be able to create a list that defines these variables to the products.

Thank you for your help

**DJunqueira** · 03-28-2024, 01:12 AM

Welcome to the forum.

Please attache a file and help us to help you.

**maiykl** · 03-28-2024, 09:11 AM

Thank you for your reply. I have uploaded a representative data sheet Diet_Plan.xlsx

I dont want it to be hardcoded, I want it to function automatically when I use the plan and fill in the product names and quantity, it should give me the total calories.

How can I implement the logic behind the quantity? The system must know that rice is calcualted with 100g increments and Bread with pcs. These information should be assigned in the list/register.

**DJunqueira** · 03-28-2024, 10:23 AM

Could use this.

Formula:

Please Login or Register  to view this content.

**AliGW** · 03-28-2024, 10:29 AM

Administrative Note:

Welcome to the forum.

Although we value your privacy as much you do, it could be important that members have a rough idea of your location as the solutions they offer may be affected by your locale. For instance, you might in the future post questions which are related to your regional settings.

With this in mind, please update your profile to something more precise (something such as UK, Europe, USA, UAE, etc. will suffice).

Thank you for helping us to help you.

Administrative Note:

Is your forum profile showing the Excel PRODUCT that you need this to work for?

Members will tailor the solutions they offer to the Office PRODUCT (Excel, NOT Windows) that you have. Please check that your forum profile is up-to-date in this respect. If you aren't sure, in Excel go to File | Account and report what it says below the MS logo at the top of that page. If your product is for Mac, please also state this.

The three most recent Excel products are Excel 2019, Excel 2021 and MS365 - if you are using MS365, please give this name along with the version number in your profile (e.g. MS365 Version 2306). This is in the About Excel section further down the Account page.

Thanks.

**maiykl** · 03-28-2024, 10:35 AM

Your help is appreciated! I will implement it in my sheet, thank you

**AliGW** · 03-28-2024, 10:36 AM

Please take note of post #5 and update your profile accordingly. Thanks.

**maiykl** · 03-31-2024, 10:18 PM

Hey,

I am back again with a question concerning your code. I changed the quantity type from "200 g" to "200" and "1 Pcs." to "1" to simplify it, but the code stopped working after that change. It seems that there must appear a letter or number after the quantity number to make it work, but I dont get why it actually needs this. I tried to understand the code and the part where this part is defined but I couldnt grasp it. Could you explain it to me?

**azumi** · 04-01-2024, 12:43 AM

Maybe:

=IFERROR(IFERROR(TEXTBEFORE($G9," ",1),"")/IFERROR(INDEX(TEXTBEFORE($B$10:$B$12," ",1)+0,MATCH($F9,$A$10:$A$12,0)),"")*$C10,"")

formula from@DJunqueira works by the way

How to assign values

LinkBack

Thread Tools

Rate This Thread

Display

How to assign values

Re: How to assign values

Re: How to assign values

Re: How to assign values

Re: How to assign values

Re: How to assign values

Re: How to assign values

Re: How to assign values

Re: How to assign values

Thread Information

Users Browsing this Thread

Similar Threads

Trying to assign values from a column to specific values in a row.

Assign values to categories of values based on separate column attribute.

Applying Formula to assign numeric values to text values in sequential order

[SOLVED] Formula to assign Values from groups of Values

[SOLVED] Need to assign different gradient values based upon values

Setting threshold to assign real values to class values

assign SEQ# for same values

Bookmarks

Bookmarks

Posting Permissions