+ Reply to Thread
Results 1 to 3 of 3

[SOLVED] IF statment within IF statment?

  1. #1
    Registered User
    Join Date
    10-25-2010
    Location
    Australia
    MS-Off Ver
    Excel 2003
    Posts
    8

    [SOLVED] IF statment within IF statment?

    Hullo!

    Hopefully this will be the last silly question from me! The spreadsheet I'm working on is nearly complete!

    Though, now I'm trying to put an IF statement within other and I'm not too sure if Excel will allow this. Below is what I'm trying to do

    =IF(D11 = "", "", "=IF(NOW()>=D5+25/1440,"Update","Waiting")")

    If I try

    =IF(D11 = "", "", "TEST")

    It works fine. What are your thoughts, am I trying to do some so silly its beyond comprehension?
    Last edited by DaZombie; 10-27-2010 at 12:37 PM. Reason: [SOLVED]

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,169

    Re: IF statment within IF statment?

    Try
    =IF(D11 = "", "", IF(NOW()>=(D5+25/1440),"Update","Waiting"))

  3. #3
    Registered User
    Join Date
    10-25-2010
    Location
    Australia
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: IF statment within IF statment?

    Quote Originally Posted by MarvinP View Post
    Try
    =IF(D11 = "", "", IF(NOW()>=(D5+25/1440),"Update","Waiting"))
    That worked like a charm, you are a champion!

+ Reply to Thread

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