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

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

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).

edit retag 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.

( 2020-06-28 12:39:14 +0200 )edit

Sort by » oldest newest most voted

Hello,

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])

more