Results 1 to 4 of 4

Excel if statements

Threaded View

  1. 01-16-2023, 01:50 AM #1
    Anya_forger12
    Anya_forger12 is offline
    Registered User
    Join Date
    10-12-2022
    Location
    Riyadh
    MS-Off Ver
    365
    Posts
    3

    Excel if statements

    hi !

    I need your help please.
    I cannot figure out what is the problem on my what if statements

    I entered the date 16 Jan 2023 and it says about to expire which should be expire since the date today is 16 Jan 2023

    =IF(ISBLANK(I2),"Not Done",IF(I2<TODAY(),"Expired",IF(I2<=TODAY()+30,"About to Expire","Valid")))



    Thank you
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] If statements and Select statements in active controls userform
    By LaSouth1776 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-05-2020, 03:17 AM
  2. [SOLVED] how to use if and statements in excel
    By Arpita_Excel in forum Excel General
    Replies: 3
    Last Post: 07-22-2015, 03:11 AM
  3. [SOLVED] If then statements on excel
    By trevor2524 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-25-2013, 03:51 PM
  4. Reading If statements and formulating values from if statements
    By crnam in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-16-2013, 05:20 AM
  5. Nested IF statements or CHOOSE statements needed for multiple conditions formula
    By salmansaif in forum Excel General
    Replies: 12
    Last Post: 05-15-2009, 08:38 AM
  6. [SOLVED] operator statements, shorting when reusing one of the statements?
    By KR in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-04-2005, 02:05 PM
  7. Help in using 'IF' statements in Excel
    By sunnyvale1 in forum Excel General
    Replies: 1
    Last Post: 04-29-2005, 12:22 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1