abbie.smith90’s Profile

Community member since May 2019

points
16

1

Hi 

 

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",