Forum Discussion
Solved
IF, AND, OR HELP
Hello team, I'm reaching out regarding this previous post: https://techcommunity.microsoft.com/t5/excel/if-and-or-help/m-p/3602812/highlight/true I'm struggling again with formulas. What I'm ...
=IFERROR(AVERAGE(IF('Dashboard Data'!$B$2:$B$22=$A4,IF('Dashboard Data'!$G$2:$G$22>=0.8,5,IF('Dashboard Data'!$G$2:$G$22>=0.7,4,IF('Dashboard Data'!$G$2:$G$22>=0.6,3,IF('Dashboard Data'!$G$2:$G$22>0.5,2,IF('Dashboard Data'!$G$2:$G$22<=0.5,1,""))))))),"")For the AVERAGE in column G you can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
Sheet "Dashboard Data":
=IFERROR(AVERAGE(IF('Dashboard Data'!$B$2:$B$22=$A4,IF('Dashboard Data'!$G$2:$G$22>=0.8,5,IF('Dashboard Data'!$G$2:$G$22>=0.7,4,IF('Dashboard Data'!$G$2:$G$22>=0.6,3,IF('Dashboard Data'!$G$2:$G$22>0.5,2,IF('Dashboard Data'!$G$2:$G$22<=0.5,1,""))))))),"")For the AVERAGE in column G you can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
Sheet "Dashboard Data":
Thank you! It worked 🙂