Hello there,
Can someone please help me fix the formula in my variance report?
In my sample template, Person A should be overutilized since his actual hour is greater than than as planned. However, i'm getting an "underutilized" result. I suspect there is something wrong with the formula in the Planned hours column -- IFERROR((VLOOKUP(B3,I13:J14,2,0)*8),"0"). Even if the value is "zero", the formula in Status column take it as Planned (0) is greater than the Actual (32).
Thanks in advance.
Bookmarks