I have several new formulas that I've been working on. One
oversimplified example being:
=LOOKUP("lion",{"bird","cat","dog","lion";"chirp", "meow","bark","roar"})
It seems that the first set of LOOKUP values must be in consecutive
(alphabetic) in this examle, in order to return the expected value. Is
there a way to overcome this limitation?
Also, I understand that the MOD function returns the remainder after a
number is divided by a divisor. But exactly how is it that MOD(NOW(),1)
returns only the date?
Thanks.
ep
--
edwardpestian
------------------------------------------------------------------------
edwardpestian's Profile:
http://www.excelforum.com/member.php...o&userid=33809
View this thread:
http://www.excelforum.com/showthread...hreadid=555301