AnsweredAssumed Answered

Help with If statement

Question asked by danlee on Dec 16, 2014
Latest reply on Dec 17, 2014 by philmodjunk

Title

Help with If statement

Post

If a calculation for BMRCalculator field is under 1200 then I want this formula to run.  This formula is in the CalorieNonWODay field.  I want 1200 to be default number that shows up for CalorieNonWODay unless the total for BMRCalculator is 1200 or greater.  How do I add that option to this formula?

Case ( ActivityLevelPossibleDelete = "Sedentary" ;(1.2 * BMRCalculator) - 500;
ActivityLevelPossibleDelete = "Lightly active (light exercise 1-3 days/week)";(1.375 * BMRCalculator) - 500;
ActivityLevelPossibleDelete = "Moderatetely active (moderate exercise 3-5 days/week)" ;(1.55 * BMRCalculator) - 500;
ActivityLevelPossibleDelete = "Very active (hard exercise 6-7 days a week)" ;(1.725 * BMRCalculator)-500)

Outcomes