Help with an IF formula?

1

Sorry…this is probably so simple but my brain cannot figure it out this morning. I am working on an ingredient tracker. Folks can enter the item in lbs. or grams. Ultimately, I need the answer in grams. So I want to say "If entered in lbs, convert to grams. Otherwise, leave as grams. " I thought it might be better to have two columns (lbs and grams) and then a 3rd grams column.
Ingredient_and_recipe_calculator_2023_·_Ingredients

Screenshot attached.

Thx!

2

Hi @Hope_Lawrence1 :blush: !

Maybe this could work :blush:

(From my quick search, as lb is not a unit we use here, 1 lb = 453.59237 g)

If(
  // if there's a value in thisRow.[Purchase in lbs.]
  thisRow.[Purchase in lbs.],
  // converts the lb(s) in g
  thisRow.[Purchase in lbs.] * 453.59237,
  // else, return the g
  thisRow.[Purchase in grams]
)

Or

If(
  thisRow.[Purchase in lbs.].IsNotBlank(),
  // converts the lb(s) in g
  thisRow.[Purchase in lbs.] * 453.59237,
  // else, return the g
  thisRow.[Purchase in grams]
)
3

You are a star, thank you! Trying this now.

4

My pleasure @Hope_Lawrence1 :grin: !

1 Like
5

It worked! Thanks! :grinning:

6

My pleasure once again @Hope_Lawrence1 :grin: !
Glad to know it works as expected and helped you moving forward :raised_hands: !

2 Likes
7

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.