Results 1 to 27 of 27

adding to formula revised

Threaded View

  1. #1
    Forum Contributor
    Join Date
    10-07-2006
    Posts
    182

    adding to formula revised

    how can i add -(q10:q11) to the following formula with out returning #VALUE in cell N9, n9 is where this formula is

    =IF(AND(ISBLANK(D9),ISBLANK(E9)),"",IF(24*(IF(E9>D 15,D15+2-E9,D15-E9))=0,24,24*(IF(E9>D15,D15+3-E9,D15-E9))))

    i have tried adding the following to the formula -(q10:q11)

    but does not work

    please download my work sheet to see what i mean

    q10 and q11 do have formulas in them.
    Attached Files Attached Files

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