Results 1 to 7 of 7

IF with two ANDs and 3 answers

Threaded View

jomili IF with two ANDs and 3 answers 10-26-2010, 11:34 AM
contaminated Re: IF with two ANDs and 3... 10-26-2010, 11:39 AM
6StringJazzer Re: IF with two ANDs and 3... 10-26-2010, 11:48 AM
DonkeyOte Re: IF with two ANDs and 3... 10-26-2010, 11:56 AM
jomili Re: IF with two ANDs and 3... 10-26-2010, 12:36 PM
jomili Re: IF with two ANDs and 3... 10-26-2010, 12:48 PM
DonkeyOte Re: IF with two ANDs and 3... 10-26-2010, 01:12 PM
  1. #1
    Valued Forum Contributor
    Join Date
    12-02-2009
    Location
    Austin, Tx
    MS-Off Ver
    Office 365 64-Bit, 2108, build 14326.21018
    Posts
    4,054

    IF with two ANDs and 3 answers

    I'm stuck on syntax. Here's my problem:
    Column Q contains Current Balance of Overtime Hours
    Column R contains OT earned in a specified period
    Column S contains Yes or No (whether to pay out or not)

    In column T I want this:
    IF(S="Yes") AND Q>R, answer would be R
    IF(S="Yes") AND Q<R, Answer would be Q
    IF(S="No"), Answer would be 0.

    I'm getting my head all twisted around trying to create the formula. Can anyone help?

    Thanks,
    John
    Last edited by jomili; 10-26-2010 at 12:50 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