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 gkittelson 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: *

  1. TravisRabe

    Testing for NULL cells and returning values

    I figured it out - thanks. It was a matter of putting the check mark in the change NULL to default values - THANKS.
  2. TravisRabe

    Testing for NULL cells and returning values

    I treid what you suggested and it still takes all 431 record and immediately reduces it to 106 becuase the remaining have null values. IT will only return the fields where there is no nul value even though I am trying to test for it.
  3. TravisRabe

    Testing for NULL cells and returning values

    I have also tried this and it does the same thing. if isNULL({Schools.SchoolName}) then "CRAP HERE" else {Schools.SchoolName}
  4. TravisRabe

    Testing for NULL cells and returning values

    Hello, I have been trying to use a formula to test cells for NULL. IF they are null I want it to return a string, if it's not NULL, I want it to return the string in the cell. However, everytime I do this, it automatically reduces the number of records to those only containing a string...

Part and Inventory Search

Back
Top