+ Reply to Thread
Results 1 to 4 of 4

if format

  1. 08-14-2015, 05:04 PM #1
    ammartino44
    ammartino44 is offline
    Forum Contributor
    Join Date
    08-14-2013
    Location
    LA Baby!!
    MS-Off Ver
    Excel 2007
    Posts
    1,598

    if format

    How do I write if 4 then this, if 5 then this, if other then this.
    Reply With QuoteRegister To Reply
  2. 08-14-2015, 05:07 PM #2
    ConneXionLost
    ConneXionLost is offline
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: if format

    How about:

    Please Login or Register  to view this content.
    Cheers,
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.
    Reply With QuoteRegister To Reply
  3. 08-14-2015, 05:21 PM #3
    ammartino44
    ammartino44 is offline
    Forum Contributor
    Join Date
    08-14-2013
    Location
    LA Baby!!
    MS-Off Ver
    Excel 2007
    Posts
    1,598

    Re: if format

    That doesn't get the logic quite right. I tried this =IF(LEFT(A2,1)=3,(D2-C2),IF(LEFT(A2,1)=4 or Left(A2,1=5),(C2-D2),0))
    Reply With QuoteRegister To Reply
  4. 08-14-2015, 05:26 PM #4
    salim ali
    salim ali is offline
    Forum Contributor
    Join Date
    04-15-2015
    Location
    beirut
    MS-Off Ver
    2010
    Posts
    107

    Re: if format

    do you want samething like this
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Mac converting excel cell formats from general format to date format
    By mrichard in forum Excel General
    Replies: 2
    Last Post: 06-02-2015, 08:42 AM
  2. Use format of one cell to change type of format used in conditional format
    By r.coon in forum Excel General
    Replies: 3
    Last Post: 02-24-2015, 02:58 AM
  3. Need assistance converting times stored in date format to number format.
    By halabis in forum Excel General
    Replies: 5
    Last Post: 04-01-2014, 09:37 AM
  4. [SOLVED] Require vba or formula for convert general format data in date format
    By santosh226001 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-10-2013, 03:53 AM
  5. [SOLVED] Need conditional format to check prior sheet for a given number and change format if found
    By Bearded Dan in forum Excel General
    Replies: 3
    Last Post: 05-15-2013, 12:16 AM
  6. Number Format:How to format say 123456789 in the format 12,34,56,789
    By harikrish in forum Excel General
    Replies: 1
    Last Post: 09-10-2005, 05:05 AM
  7. how to format excel format to text format with separator "|" in s.
    By azlan in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 01-31-2005, 09:06 AM

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


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1