Calculating fractions of a teaspoon

[gmagerr]

Hello,

I have a spreadsheet i'm using to make something. I have a total batch size that's in grams. I have 3 columns, one is percentage, one is actual amount, and finally how much of a teaspoon those equate to. I'm trying to see if it's 1/8, 1/16, 1/4, etc.

Here are my formulas
Cell G47 is the batch size of 226 grams. No formula
Cell E64 is the percentage of the ingredient I want to add. No formula
Cell F64 is where I'm calculating how much is in the batch. Here's the formula =($G$47*E64)
Cell G64 is where i'm trying to calculate how much of a teaspoon everything is. Here's the formula =IF(F64=0,"0/0",TEXT(F64,"#/#")) & " tspn"
Not sure if I'm doing it right. I change the percentage, and I get all kinds of different fractions like 5/9, 7/2 12/14, I only want to know if it is like 1/32, 1/16, 1/8, 1/4, etc.

Not sure what to do here so any help is appreciated
Thanks

 

[steve the fish]

Well that would depend on how much in terms of grams a teaspoon held. That would be different for each ingredient based on its density.

 

[thisoldman]

Removed by author.

 

[gmagerr]

Well that would depend on how much in terms of grams a teaspoon held. That would be different for each ingredient based on its density.

1 teaspoon = 5 grams

 

[barry houdini]

You could try rounding to the nearest 1/32 e.g. something like this

=IF(F64=0,"0/0",TEXT(MROUND(F64,1/32),"#/##"))

 

[Marcelo Branco]

Following Barry's idea (post 5), if the desired is a fraction of the total i think the formula should be

=IF(F64=0,"0/0",TEXT(MROUND(F64/G47,1/32),"#/##"))

M.