We will be migrating from Ask to Discourse on the first week of August, read the details here

Ask Your Question

Calculating from different 0.x values to the needed specific single value

asked 2020-06-28 11:54:40 +0200

SrutrA gravatar image

On column D you can see the 0.x of a kilogram (0.75, 0.38 etc). On columns E, F, and G there are nutrition values for the specific 0.x of a kilogram (from column D). What I've been trying to figure out for 3+ hours is how to fill columns H, I, and J where I need to input the results from E, F, and G for precisely 100 grams (0.1 of a kilogram).

image description

edit retag flag offensive close merge delete


A hint from school math: if X kg of product has N (calories or g protein or ...), then 1 kg has N/X (calories or g protein). And 100 g has it 10 times less. So just dividing your E by D and then by 10 will give you how many E is in 100 g.

Mike Kaganski gravatar imageMike Kaganski ( 2020-06-28 12:39:14 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2020-06-28 12:48:48 +0200

Opaque gravatar image


Hm - not sure whether I interpret your question right (you did not give any explanation of the column)

  • H1:=(E1/$D1)*0.1
  • I1: =(F1/$D1)*0.1
  • J1: =(G1/$D1)*0.1

(parentheses are in fact not required)

Note This answer assumes that your data are real numbers and not text looking like numbers (this implies the decimal character in the cells language is a . [dot])

edit flag offensive delete link more


Solved with "=IF(D13<>"", ROUND(G13 * 0.1 / D13,2), "")". Now the problem is the last decimal rounding up to "0", despite I included the "2".

SrutrA gravatar imageSrutrA ( 2020-06-28 13:00:44 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-06-28 11:54:40 +0200

Seen: 27 times

Last updated: Jun 28 '20