Average days returns 1 value if 0 and the average value if >0

michael.vanhuss
michael.vanhuss ✭✭
edited 12/09/19 in Formulas and Functions

I'm trying to have the value of a cell say same day in the event the average number of days is 0. I want to return the average number of days id greater than zero. Everytime I add an else statement it becomes unparsable. Here is what I have.

=IF(AVG({Field Scheduler Test Range 1}), 0, "Same Day", (AVG({Field Scheduler Test Range 1}))

Comments

  • L_123
    L_123 Community Champion

    format for an if statment is

    =if(criteria,true,false)

    you have

    =if(average,expected return, true, false

    =IF(AVG({Field Scheduler Test Range 1}) =Β 0, "Same Day", (AVG({Field Scheduler Test Range 1}))

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!