Advanvnce formula and function

[ataur rahman rony]

Hi,
I know this is a weird question. But its for learning purpose and this is a learning zone for Excel.
How can i learn Excel advance formula and function easily!!! So that i can apply formula & function.I will be very glad if someone give me some tips or any book or something else that will help you lot.
Thnx.

 

[Mandeep Baluja]

Yesterday I made this formula for someone looking a little tricky. but a simple step to make a efficient formula can be achieve with the help of practice try some shorter formulas first then try to achieve the result through some other functions. you will learn the usage of formulas and soon you will develop them without any help. first try to get the logic behind the formula.

For example : Try to get nearest value in a range as per your requirement.


=IF($K$3="ABB",IF(INDEX(A1:A195,MATCH(MIN(ABS($B$2:$B$195-M12)),ABS($B$2:$B$195-M12),0),0)<K12,"Minimum date is "&TEXT(K12,"dd-mm-yy"),INDEX(A1:A195,MATCH(MIN(ABS($B$2:$B$195-M12)),ABS($B$2:$B$195-M12),0),0))+1,IF(INDEX(A1:A195,MATCH(MIN(ABS($C$2:$C$195-M12)),ABS($C$2:$C$195-M12),0),0)<K12,"Minimum date is "&TEXT(K12,"dd-mm-yy"),INDEX(A1:A195,MATCH(MIN(ABS($C$2:$C$195-M12)),ABS($C$2:$C$195-M12),0),0)+1))



Regards,
Mandeep Baluja
LearningZmyPassion
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl