EXCEL FORMULAS

I HAVE A EXCEL SHEET LIKE THIS GIVEN BELOW

 

                                1/2/2018   2/2/2018     3/2/2018     4/2/2018           5/2/2018    

MAX(1%)  MIN(-4%)  -1%           -2%            -3%                 -4%                1%

 

NOW I WANT THE RESULT IN A PARTICULAR CELL THAT IT SHOWS 

 

MIN(-4%) = 4/2/2018

 

HOW TO BRING ABOVE DATE IN FRONT OF %

 

WHEN I ENTERED -2% THAN THE DATE SHOULD BE 2/2/2018

 

KINDLY HELP

By: VIVEK KUMAR

Leave a Reply

Your email address will not be published. Required fields are marked *