Forum Discussion

KW McKillop's avatar
KW McKillop
Copper Contributor
Jul 09, 2017

MS Excel - IF

Need to retain wkly readings while showing most current records in Month report. H7 IF formula OK for P7,Q7, but how do I (Nest?) IF statement for P7,Q7,R7,S7?

 

Thanks

excel
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    Jul 09, 2017

    Hi

     

    You want to retrieve the value of the rightmost cell.

    =LOOKUP(9^9,P7:T7)

    The search criteria has to be greater than any number in the search vector.

    And 9^9 is the shortest term with 3 charcaters for a big number. Which is about 387,000,000.

    If your values exceed this number then you would use 9^99. This the shortest term with 4 characters for a veeeeeeeeeeeeeeeeeery big number. Which is about 2.95127E+94.

     

     

Resources