+ Reply to Thread
Results 1 to 4 of 4

If formula problem...

  1. #1
    Forum Contributor
    Join Date
    01-22-2013
    Location
    Pekanbaru, Indonesia
    MS-Off Ver
    Excel 2013 & Google Sheet
    Posts
    1,141

    If formula problem...

    hi all,

    how to figure it out this problem, like this below :

    <style type="text/css">
    table.tableizer-table {
    border: 1px solid #CCC; font-family: Arial, Helvetica, sans-serif
    font-size: 12px;
    }
    .tableizer-table td {
    padding: 4px;
    margin: 3px;
    border: 1px solid #ccc;
    }
    .tableizer-table th {
    background-color: #104E8B;
    color: #FFF;
    font-weight: bold;
    }
    </style><table class="tableizer-table">
    <tr class="tableizer-firstrow"><th>data1</th><th>data2</th><th>after formula</th></tr>
    <tr><td>-</td><td>-</td><td>-</td></tr>
    <tr><td>-</td><td>BRI</td><td>BRI</td></tr>
    <tr><td>KPKNL</td><td>-</td><td>KPKNL</td></tr>
    <tr><td>-</td><td>BRI</td><td>BRI</td></tr>
    <tr><td>KPKNL</td><td>-</td><td>KPKNL</td></tr>
    </table>

    see my workbook attached..

    any help me, much appreciated...

    john m
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    63,649

    Re: If formula problem...

    In C2, copied down:

    =IF(AND(A2="-",B2="-"),"-",IF(A2="-",B2,A2))
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

  3. #3
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,771

    Re: If formula problem...

    Or

    In C2 Cell

    =SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2&B2,"--","^"),"-",""),"^","-")

    Drag it down...

  4. #4
    Forum Contributor
    Join Date
    01-22-2013
    Location
    Pekanbaru, Indonesia
    MS-Off Ver
    Excel 2013 & Google Sheet
    Posts
    1,141

    Re: If formula problem...

    hi, thanks all of you.....

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 1
    Last Post: 01-06-2014, 03:54 AM
  2. Replies: 7
    Last Post: 02-03-2013, 06:25 PM
  3. Replies: 2
    Last Post: 01-22-2013, 07:09 AM
  4. Problem reading formula with ActiveCell.Formula
    By Matija in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-01-2011, 06:10 AM
  5. Formula problem
    By aristotle in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-06-2005, 03:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1