Visokio website     Downloads     Video tutorials     KnowledgeBase  
"If" simple but doesn't work on blank cells - Visokio Forums
"If" simple but doesn't work on blank cells
  •     dszl136154 March 20, 2012 7:05AM
    Basically I have a new column "Group" with formula behind:
    IF([Ad group raw]="",[Ad content],[Ad group raw])

    “Ad group raw” has some empty cells. So I want "Group" column to copy "Ad group Raw" content into cells where "Ad Group raw" has empty cells. The remaining "Group" should have content from "Ad group raw".

    Why is it not working?
  • 2 Comments
  •     indranildatta March 20, 2012 7:08AM
    Hi Darek,

    Could you please try this and let me know if it worked:

    IF([Ad group raw]=null,[Ad content],[Ad group raw])

    Cheers!
    Indranil
    Indranil Datta
    Invizua Limited - www.invizua.com - Dedicated to Media, Marketing Services and Market Research Organisations
    M: +44 7956 470 046 | E: indranil.datta@invizua.com | Skype: indranildatta1 | LinkedIn: www.linkedin.com/in/indranildatta | Twitter: @indranildatta

    Address: Studio 6, 36-42 New Inn Yard, London EC2A 3EY
  •     indranildatta March 21, 2012 8:12AM
    Hi Darek,

    Thanks for letting me know that using 'null' fixed it.

    Cheers!
    Indranil
    Indranil Datta
    Invizua Limited - www.invizua.com - Dedicated to Media, Marketing Services and Market Research Organisations
    M: +44 7956 470 046 | E: indranil.datta@invizua.com | Skype: indranildatta1 | LinkedIn: www.linkedin.com/in/indranildatta | Twitter: @indranildatta

    Address: Studio 6, 36-42 New Inn Yard, London EC2A 3EY
Add a Comment

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership

Categories