Thread: Stinking Excel....
View Single Post
rick-l rick-l is offline
Registered
 
Join Date: May 2002
Location: St Louis
Posts: 4,211
Re: Stinking Excel....
Quote:
Originally posted by Highlander179
Why wont this work?

39234_<_TODAY_()_<_39340
Is that a valid logical test in XL?


today is 39233 also


edit does this work?

=IF(AND(39234_<_TODAY_()_,TODAY_()_<_39340),10%,0)
Last edited by rick-l; 05-31-2007 at 02:25 PM..
Old 05-31-2007, 02:04 PM
  Pelican Parts Catalog | Tech Articles | Promos & Specials    Reply With Quote #4 (permalink)