+ Reply to Thread
Results 1 to 3 of 3

what can I use insted of KONT_ALLOMANY[KOCKAZAT_VEGE]="" Calculated Columns

  1. #1
    Registered User
    Join Date
    10-29-2014
    Location
    Budapest
    MS-Off Ver
    2013
    Posts
    2

    Question what can I use insted of KONT_ALLOMANY[KOCKAZAT_VEGE]="" Calculated Columns

    HI there,

    this calculated columns worked in excel 2010 but in excel 2013 it doesnt work...

    =if(KONT_ALLOMANY2[KOCKAZAT_KEZDETE]=KONT_ALLOMANY2[KOCKAZAT_VEGE],0,if(KONT_ALLOMANY2[KOCKAZAT_KEZDETE]>40178,0,if((if(or(KONT_ALLOMANY2[KOCKAZAT_VEGE]="",KONT_ALLOMANY2[KOCKAZAT_VEGE]>40178),40179,KONT_ALLOMANY2[KOCKAZAT_VEGE]+1)-KONT_ALLOMANY2[KOCKAZAT_KEZDETE])/365<0,0,(if(or(KONT_ALLOMANY2[KOCKAZAT_VEGE]="",KONT_ALLOMANY2[KOCKAZAT_VEGE]>40178),40179,KONT_ALLOMANY2[KOCKAZAT_VEGE]+1)-KONT_ALLOMANY2[KOCKAZAT_KEZDETE])/365)))

    I would be happy if somebody could help me...

    Thanks,
    George

  2. #2
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: what can I use insted of KONT_ALLOMANY[KOCKAZAT_VEGE]="" Calculated Columns

    This is a PowerPoint forum - I guess you are talking about Power Pivot?

    What exactly do you mean by "doesn't work"?
    Remember what the dormouse said
    Feed your head

  3. #3
    Registered User
    Join Date
    10-29-2014
    Location
    Budapest
    MS-Off Ver
    2013
    Posts
    2

    Re: what can I use insted of KONT_ALLOMANY[KOCKAZAT_VEGE]="" Calculated Columns

    you are right, sorry

    meanwhile I solve my problem. thanks

+ 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: 0
    Last Post: 11-22-2013, 01:36 PM
  2. Replies: 3
    Last Post: 03-08-2013, 09:28 AM
  3. Replies: 0
    Last Post: 01-09-2013, 06:52 PM
  4. Replies: 9
    Last Post: 09-05-2012, 10:23 AM
  5. "Calculated Formula value" to "Text"
    By STROBE in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 03-11-2008, 09:24 AM

Tags for this Thread

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