Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ols01088
  • Order by date
  1. ols01088

    IF statements referring to blank cells

    Is there a reason for using in your formula "3","1","0" instead of using 3,1,0? Do you want to test text or numbers?
  2. ols01088

    Excel Formula Help

    Try this. Define name B3 = YYYY Define name range B4:M4 = HELP input B3 : year (e.g. 2003) copy this formula into B5 =DATE(YYYY;COLUMN()-1;1) right copy this formula from B5 into range B5:M5 format B5:M5 = mmm or mmmm copy this formula into B4 =IF(B6<>0;MONTH(B5);&quot;&quot;) right...

Part and Inventory Search

Back
Top