Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Sep 2002
    Posts
    210
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I'm having a horrible time with an IF/THEN statement in a complicated timecard. What I would like is if is X45 is greater than 0, then AA39 would copy the value from Y39.

    Formula I'm trying to use/struggling with: =IF(X45>=0,X45=Y39," ")

    Can anyone see the error at a quick glance?

    Thanks.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Try

    =IF(X45>0,Y39,"")

    This formula should be in cell AA39.

Posting Permissions

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