+ Reply to Thread
Results 1 to 3 of 3

IF Statment - Carry common part of IF Statment for entire column

  1. #1
    Forum Contributor
    Join Date
    08-22-2005
    MS-Off Ver
    Office 365
    Posts
    342

    Question IF Statment - Carry common part of IF Statment for entire column

    Hello,

    Here is what I have.

    In E2 I have a date.
    In AK1 I have the following =TODAY () - Will always populate with the current date.

    In AK2 I have and IF Statment:

    =(F2="",AK1-E2,O)

    So if F2 is blank ... AK2 will display the numbers of days F2 has been blank. If it is not blank it will return a 0.

    However when I go and copy the IF statment down the column of AK3 : .... The AK1 changes to AK3, AK4 etc ...

    I need it to stay as AK1 considering that is where todays date will always be.

    Thoughts ?

    Thanks in Advance.
    Last edited by SVTF; 06-06-2012 at 11:23 PM.

  2. #2
    Forum Moderator vlady's Avatar
    Join Date
    09-22-2011
    Location
    Philippines - OLSHCO -Guimba-Nueva Ecija
    MS-Off Ver
    2021
    Posts
    4,361

    Re: IF Statment - Carry common part of IF Statment for entire column

    Maybe like this???

    $AK$1
    I think people forget the word "THANK YOU!!!!" Do you still know it???

    There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "

    Regards,
    Vladimir

  3. #3
    Forum Contributor
    Join Date
    08-22-2005
    MS-Off Ver
    Office 365
    Posts
    342

    Re: IF Statment - Carry common part of IF Statment for entire column

    Quote Originally Posted by vlady View Post
    Maybe like this???

    $AK$1
    Worked like a charm - Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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