+ Reply to Thread
Results 1 to 3 of 3

Thread: IF cell does not contain 'blah' then show 'this'

  1. #1
    CCCSteve
    CCCSteve is offline
    Barn Regular CCCSteve is on a distinguished road CCCSteve's Avatar
    Join Date
    Feb 2010
    Posts
    63
    Rep Power
    2

    IF cell does not contain 'blah' then show 'this'

    So I am finishing a report and the data is all correct and everything but as a superficial request I need to change a value that = 'NaN' to just show 'N/A' instead. How can I get this to work? I have tried IIF statements but it doesn't seem to pan out. Thanks for any help.
    CCCSteve, March 2nd, 2010 02:49 PM
    Reply With Quote Reply With Quote
  2. #2
    CCCSteve
    CCCSteve is offline
    Barn Regular CCCSteve is on a distinguished road CCCSteve's Avatar
    Join Date
    Feb 2010
    Posts
    63
    Rep Power
    2

    Nevermind

    I retract my question. Aparently I needed to check the value against 0 and not "NaN"
    CCCSteve, March 2nd, 2010 03:03 PM
    Reply With Quote Reply With Quote
  3. #3
    Lauramc
    Lauramc is offline
    I like Data Cubes too... Lauramc has a spectacular aura about Lauramc has a spectacular aura about Lauramc's Avatar
    Join Date
    Mar 2008
    Location
    Far Far Away
    Posts
    387
    Real Name
    Laura
    Rep Power
    5

    I'm glad you got it sorted Thanks for sharing the solution.
    Lauramc, March 4th, 2010 03:37 PM
    "The Enrichment Center is required to remind you that first you will be baked, then there will be cake." - GLaDOS
    Reply With Quote Reply With Quote
+ Reply to Thread
« Previous Thread | Next Thread »

Similar Threads

  1. Dynamic change of cell info based on user input?
    By CCCSteve in forum SQL Server Reporting Services Help
    Replies: 3
    Last Post: February 22nd, 2010, 05:06 PM
  2. table cell problem
    By todd2006 in forum HTML & CSS Help
    Replies: 9
    Last Post: September 4th, 2009, 02:06 PM
  3. Show/hide insert
    By dtz in forum JavaScript Programming
    Replies: 5
    Last Post: March 23rd, 2009, 12:38 PM
  4. show/hide code cannot use in more than one box
    By dtz in forum JavaScript Programming
    Replies: 7
    Last Post: March 16th, 2009, 12:37 PM
  5. Dynamically Reference Worksheet Cell/Range
    By BLaaaaaaaaaarche in forum Microsoft Office
    Replies: 2
    Last Post: June 18th, 2008, 04:59 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


SEO by vBSEO