+ Reply to Thread
Results 1 to 4 of 4

HELP -> Last true formula result appearing wen the condition turns false..

  1. #1
    Registered User
    Join Date
    03-06-2005
    Posts
    4

    HELP -> Last true formula result appearing wen the condition turns false..

    Hi, I have this formula

    =IF(TODAY()<AE$3;$E4-SUM($I4:AC4); ?????? )

    AE$3 ->Is a date
    $E4 ->is number witch is changing every days.

    My problem is what do I put in the "??????" (condition_if_false) to apear the last calculated true value.
    Maybe ther's a completely difererent way to do so...

    Please help

  2. #2
    Forum Contributor
    Join Date
    08-23-2004
    Posts
    210
    Was this formula done in OOo calc (Open Office Spreadsheet)? "=IF(TODAY()<AE$3;$E4-SUM($I4:AC4); ?????? )". I ask this because of the semi-colons used in your formula. Excel uses a comma rather than a semi-colon - so that wouldn't help. I'm no expert, but I'm rather puzzled about $E4's role. Hopefully, someone will soon provide the answer.

  3. #3
    Registered User
    Join Date
    03-06-2005
    Posts
    4
    I use excel 2002, it's just in another language.
    I can't see were you think it sould be a comma, the formula is working fine. what I need is annother formula to put in the false condition.
    $E3 is annother formula connected to a web link witch updates every now an then.
    Last edited by milton; 03-06-2005 at 08:12 AM.

  4. #4
    Registered User
    Join Date
    03-06-2005
    Posts
    4
    ok, now I think the solution may be a macro, but I stil don't know what to do..
    Is there a way to make a macro that records the last calculated value before it passes to the false condition and then substitute the equasion in the cell for that value only deliting, or editing, the existing equasion??

+ 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