Results 1 to 11 of 11

Another if then statement

Threaded View

  1. #1
    Forum Contributor jonvanwyk's Avatar
    Join Date
    06-28-2010
    Location
    Iowa, USA
    MS-Off Ver
    Excel 2010
    Posts
    452

    Another if then statement

    =IF(OR(C5="V1",C5="V2",C5="V3"),B6-B5,B6)
    In the above code, B5 is "7:00" while B6 is "11:00". Since "V1" was selected for C5, it should subtract 7:00 from 11:00 and return a value of 4 (hours). If V1 had not been selected, it should just display 11:00 (the value of B6).
    Last edited by jonvanwyk; 12-12-2010 at 02:51 PM.

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