[Solved] Food recipe calculator

Discuss the spreadsheet application

[Solved] Food recipe calculator

Postby Giuseppe.btc » Wed Nov 06, 2019 7:45 am

Hi everyone,

I'm trying to create my food recipe cost calculator and I'd like to create a calculator page (easy enough) and a pantry page (2 columns Ingredient and cost per unit).
I'd like to choose from a dropdown in the calculator the ingredient from the pantry and have a cell beside give me the price per unit from the pantry, that way it is easy for me to create the formulas without every time modify the calculator page.

I hope it is an easy task for calc veterans.

tank you.
Giuseppe
Last edited by Hagar Delest on Fri Nov 08, 2019 9:17 am, edited 1 time in total.
Reason: tagged solved
Open office 4.1.7
Windows 10
Giuseppe.btc
 
Posts: 3
Joined: Wed Nov 06, 2019 7:37 am

Re: Food recipe calculator

Postby Zizi64 » Wed Nov 06, 2019 8:19 am

I'd like to choose from a dropdown in the calculator the ingredient from the pantry and have a cell beside give me the price per unit from the pantry,


Try the function VLOOKUP(). That is the English name of the function, I do not know what locale settings are you using.

Please upload a small ODF type sample file here.
Tibor Kovacs, Hungary; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.0; AOO4.1.6
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
User avatar
Zizi64
Volunteer
 
Posts: 8752
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Food recipe calculator

Postby Giuseppe.btc » Fri Nov 08, 2019 2:01 am

I upload the example, as you can see I'd like to have a drop list for the ingredient and have the price change following the pantry sheet prices
Attachments
foodcalculator.ods
(17.93 KiB) Downloaded 12 times
Open office 4.1.7
Windows 10
Giuseppe.btc
 
Posts: 3
Joined: Wed Nov 06, 2019 7:37 am

Re: Food recipe calculator

Postby RusselB » Fri Nov 08, 2019 4:50 am

The formula, using US English, for the entry on row 3 would look like
Code: Select all   Expand viewCollapse view
=VLOOKUP(A3;Pantry.A$2:B3;2;0)
OpenOffice 4.1.7 and LibreOffice 6.3.3.2 on Windows 7 Pro & Ultimate
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
RusselB
Moderator
 
Posts: 5848
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Food recipe calculator

Postby Giuseppe.btc » Fri Nov 08, 2019 5:03 am

Thank you very much
Open office 4.1.7
Windows 10
Giuseppe.btc
 
Posts: 3
Joined: Wed Nov 06, 2019 7:37 am


Return to Calc

Who is online

Users browsing this forum: MSN [Bot], Stockman1 and 16 guests