Forum Discussion
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
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.