I am looking to do a nested if so if a value is x y is returned, see below details-;


  • IF COM = A
  • IF CR = B
  • IF HAR = C
  • IF ARF = D
  • IF AR = E
  • IF PSRF = F
  • IF PSR = G
  • IF 2020 PSR = L

I am having an issue with the below formula's (whichever way round I put it):


=IF(Type117 = "PSR", "G",


I used the dashboard as a way to communicate to many within our organization, as many of you do. Recently, this week, it looks like now when anyone clicks on any link within the dashboard a new window opens rather than a new tab within the same window. Also the new Tab is not expandable. I do not