+ Reply to Thread
Results 1 to 3 of 3

Basic IF problem!

  1. #1
    Registered User
    Join Date
    08-13-2012
    Location
    Bristol
    MS-Off Ver
    Excel 2003
    Posts
    2

    Wink Basic IF problem!

    Hi everyone,
    I'm new to excel and trying to write the following basic formula, can anyone help me?

    If AF3 is greater than or equal to 5, and less than 6, then "1", otherwise "".

    Thank you!

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Basic IF problem!

    HI m_blanks,

    Welcome to the forum.

    Try using below formula:-

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey, Excel rMVP
    +919810929744 (India), +971528225509 (Dubai), [email protected]

  3. #3
    Registered User
    Join Date
    08-13-2012
    Location
    Bristol
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Basic IF problem!

    Thank you, I shall try it tomorrow and let you know how it goes!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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