Forum Discussion
Problem with IF function
Please refer to the attached file. I need the worksheet to work in this way. If the calculated duration is more than 56, the value in the 'COLD' row must increase by 1. If the calculated durat...
Hello Ingeborg
If your speculation is correct I would insert an additional column "Condition".
=LOOKUP(Table1[Duration],{0,10,56.0001},{"Hot","Warm","Cold"})And then I would insert a pivot table with "Condition" in row area and in values.
Yes, that approach is possible, but the Lookup function may be beyond the comfort zone of some people.
The beauty of Excel is that there is always half a dozen ways to do things, depending on where folks are in their particular learning journey.
Formulas are often the first step. Pivot tables will come a bit later. Undocumented functions like Lookup() are showing in the documentation as for compatibility to earlier versions, so that will freak people out.
I like to keep it nice and simple and build on that over time.