Results 1 to 2 of 2

Thread: If function Problem

  1. #1

    If function Problem

    Register for a FREE account, and/
    or Log in to avoid these ads!

    If function Problem

    i have a time sheet.
    C2 must have value if c1 bigger or equal to 7,5 =7,5
    if c1<7.5 c2 must be have digits of c1

    for example
    1 8
    2 7.5
    1 4
    2 4

    how i must write formula
    thanks before
    Attached Files Attached Files

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Nanaimo, BC, Canada
    Blog Entries
    Excel Version
    Excel Office 365 Insider
    I'll give you two different ways:




    Hope that helps,
    Ken Puls, FCPA, FCMA, MS MVP

    Learn to Master Your Data at the Power Query Academy (the world's most comprehensive online Power Query training), with my book M is for Data Monkey, or our new Power Query Recipe cards!

    Main Site: -||- Blog: -||- Forums:
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

Posting Permissions

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