+ Reply to Thread
Results 1 to 4 of 4

Formula help

  1. #1
    Brett
    Guest

    Formula help

    How can I have a formula (if a2=day c2=$16.50 if a2=night c2=$25.00) ?

  2. #2
    Bob Phillips
    Guest

    Re: Formula help

    What is the definition of day and night. Let's says day is 06:00 to 18:00,
    then assuming A2 is just time

    =IF(OR(A2<--"06:00:00",A2>=--"18:00:00"),25,16.5)

    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    "Brett" <[email protected]> wrote in message
    news:[email protected]...
    > How can I have a formula (if a2=day c2=$16.50 if a2=night c2=$25.00) ?




  3. #3
    Ola
    Guest

    RE: Formula help

    Hi,

    Copy this to C2
    =IF(A2="day",16.50,IF(A2="night",25.00,"?"))

    Ola


  4. #4
    JE McGimpsey
    Guest

    Re: Formula help

    If "day" is, say 6:00 am to 5:59 pm, One way:

    =CHOOSE(2*MOD(A2+0.25,1)+1,16.5,25)




    In article <[email protected]>,
    "Brett" <[email protected]> wrote:

    > How can I have a formula (if a2=day c2=$16.50 if a2=night c2=$25.00) ?


+ 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