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!