Results 1 to 2 of 2

Thread: If formula that extracts data, needs update

  1. #1

    If formula that extracts data, needs update



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have this formula that is working fine, but now it needs to be updated to subtract one minute.

    =IFERROR(IF('SCHEDULE WEEK ONE'!$I5="OFF","",IF(AND(ISNUMBER(SEARCH($P$16,'SCHEDULE WEEK ONE'!$K5)),SEARCH($P$20,'SCHEDULE WEEK ONE'!$C5),SEARCH($P$24,'SCHEDULE WEEK ONE'!$E5),SEARCH($P$28,'SCHEDULE WEEK ONE'!$F5),SEARCH($P$32,'SCHEDULE WEEK ONE'!$G5)),(RIGHT('SCHEDULE WEEK ONE'!$I5,5))+0,"")),"")


    Tried to add it to the end within the RIGHT function but to no avail. I5 is what needs to have the one minute subtracted from it.

    This is linked to a previous thread

    http://www.excelguru.ca/forums/showthread.php?1075-Sumproduct-if-formula-to-ignore-text-string&p=4972#post4972

    Thank you I appreciate any help

    MZING81

  2. #2
    Why don't you post the workbook and tell us what the formula seeks to achieve?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •