Hi
I have a column and values in the column (A) 1,2,3,4,6,8,12,16,18,25,39,87 in rows.
Now I need that
in Cell B1 value will be input cell and Cell B2 will be output cell
I required this
if B1 is 1 then B2 is 1
if B1 is 3 then B2 is 3
if B1 is 13 then B2 is 16
NB: in Column A values are in lowest to highest order.
So please help me what will be the formula of B2.
I dont want to use VB
Bookmarks