+ Reply to Thread
Results 1 to 4 of 4

How to use OR

  1. #1
    Registered User
    Join Date
    05-24-2017
    Location
    Philippines
    MS-Off Ver
    2021
    Posts
    35

    How to use OR

    Im still bit confuse on how to manipulate OR command.. so might have another example again


    in sample, needed inputs are curing time, age & remarks
    there are 2 curing time, 7 & 28
    conditions for remarks are ff
    a) if age is less than curing time, then remarks is =" compare @ (=curing time) days"
    b) if age is greater than or equal to curing time, then remarks is ="none "




    Please see attached sample book. Thanks!
    Attached Files Attached Files
    Last edited by monskaye; 09-04-2017 at 09:46 PM. Reason: add attachement
    Newbie and still learning

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 V 2503
    Posts
    13,713

    Re: How to use OR

    Try this formula in C5
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Then copy that cell and paste into cells C8, C11 and C14.
    Dave

  3. #3
    Registered User
    Join Date
    05-24-2017
    Location
    Philippines
    MS-Off Ver
    2021
    Posts
    35

    Re: How to use OR

    Didnt thought that it was just simple command if for this problem. .. lol :D

    Thanks a lot!

  4. #4
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 V 2503
    Posts
    13,713

    Re: How to use OR

    You're welcome. Thanks for the feedback and the rep.

+ 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