Sum with Tax/word
Required formula for row A1:A5
Sum in A11 in figure & Tax/Words in A12.
A1 = 2
A2 = 3
A3 = 1
A4 = 10
A5 = 5
Ans.
A11 = 21 (In figure)
A12 = Twenty One. ( In Words)
How do I find the 2nd highest value in a series? If A1 cell & find the value between b1:m2 then I get the next highest value. I just want to know how to do the second highest. pl give the formula. Details as under.
A1=11280 then next highest value in column A3 11600
A1=14720 then next highest...