Results 1 to 8 of 8

If statement

Threaded View

  1. 12-05-2007, 05:45 PM #1
    jobo
    jobo is offline
    Registered User
    Join Date
    12-05-2007
    Posts
    9

    Smile If statement

    I have produced an excel doc which I am having probs with.
    I have entered the formula =now() into cell G1.
    I have entered a date later than now into cell G2.
    I have entered the formula =IF(G1>G2,0,1) in cell G3.

    With this configuration if G2 is later than now then G3=1 and if G2 is earlier G3=0.
    I am now trying, without success, to make all cells in the doc = 0 if G3=0 pos using a conditioning formula.

    Can Anyone help
    Last edited by jobo; 12-05-2007 at 06:00 PM. Reason: told to edit title
    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)

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