Set Minimum Output Value in Calculator Result

Ask the Community General Questions
1

Hi there! I’m building a calorie calculator and I want to apply a minimum calorie floor in one of my formula fields. Specifically, I want the final result to round up to 1100 if the calculated value is less than 1100.

I’m currently using SUM(TDEE, Goal) to calculate the daily calorie target, but I’d like to apply logic like:
“If result < 1100, then show 1100. Otherwise, show the result as is.”

Is there a way to implement this kind of conditional logic in the formula field? Or do I need to split this into multiple steps? Would love guidance on how to structure this properly in Elfsight!

(Free Calorie Calculator for Weight Loss & Body Recomposition)

Thanks!

2 Likes
3

Hey there and welcome to the Community, @Alix_Turoff :waving_hand:

I’ve checked your widget and it seems you’ve already found a solution:

image
image1553×918 65.5 KB


Could you please let me know if it’s working the way you need?

1 Like
4

Hi- I don’t want the results to show separately (the way it is now)- instead, I want there to be a way to not show the result at all if it’s under 1100 calories

2 Likes
5

Got you! In this case, you can just hide this calculation from the results :slightly_smiling_face:

image
image334×842 14.8 KB

image
image1569×949 59.9 KB

1 Like
6

Thanks so much! I think I have it working now!

3 Likes
7

You’re always welcome!

By the way, we’d like to invite you to participate in our Birthday Contest, where you can win a 12-month extension for your subscription - Birthday Contest: 10 Winners, 10 Free Years with Elfsight! :wrapped_gift:

Check the details and join in :wink:

1 Like