Forum Discussion

gretacristina's avatar
gretacristina
Copper Contributor
Nov 03, 2022
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 ...
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Nov 03, 2022

    gretacristina 

    =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":

     

gretacristina's avatar
gretacristina
Copper Contributor
Nov 03, 2022
I believe I have an older version of excel because I'm not able to use the vlookup function
Patrick2788's avatar
Patrick2788
Silver Contributor
Nov 04, 2022
That's odd that you don't have VLOOKUP. The function has been around since 1985 with Excel 1.