Friday, January 8, 2010

What is the formula to be use in ms excel to render the 2nd highest number in B1 with the follwing.....?

A1=1


A2=2


A3=3


A4=4


using IF,AND and OR function...What is the formula to be use in ms excel to render the 2nd highest number in B1 with the follwing.....?
Screw that....use:





=large(a1:a4,2)

No comments:

Post a Comment