+ Reply to Thread
Results 1 to 11 of 11

If /then statement

Hybrid View

trusky If /then statement 09-26-2008, 01:23 PM
VBA Noob One way VBA Noob 09-26-2008, 01:32 PM
malnahar Hi, If you mean to say... 09-26-2008, 02:15 PM
Paul Perhaps ... 09-26-2008, 02:38 PM
martindwilson paul that gives 1 for a2=0,... 09-26-2008, 03:59 PM
Paul Martin, extremely large... 09-26-2008, 06:16 PM
contextions Are you talking about... 09-26-2008, 08:07 PM
contextions That is kind of like the... 09-26-2008, 07:50 PM
Paul Contextions, are you serious?... 09-26-2008, 08:37 PM
contextions Theoretically you could use... 09-26-2008, 09:03 PM
protonLeah there's also this posibility:... 09-26-2008, 10:04 PM
  1. #1
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,887
    Contextions, are you serious? If so, I apologize. That post was a complete joke based on the quote "2 + 2 = 5, for extremely large values of 2." Google™ it; you can even buy t-shirts and mugs.

    Hence the "Just kidding... wink" bit.

  2. #2
    Registered User
    Join Date
    09-23-2008
    Location
    mobile
    MS-Off Ver
    07
    Posts
    43
    Theoretically you could use excel to display 2 + 2 = 5 for large values of 2 if entries were rounded to nearest .5 < higher whole number, huh? We should make a new trademark with the code!

  3. #3
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,953
    there's also this posibility:

    =--AND(A1="x",B1="x")
    Ben Van Johnson

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Create statement from cells in workbook
    By Andy Stern in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 06-04-2008, 04:46 AM
  2. Nested IF Statement with Multiple Criteria
    By Hoopsah in forum Excel General
    Replies: 6
    Last Post: 07-23-2007, 10:01 AM
  3. With Statement Questions
    By OzTrekker in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-02-2007, 02:44 AM
  4. G/L Income Statement Template Setup
    By pinny in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-28-2006, 08:12 PM
  5. advanced (i think) if statement help
    By ukrockhit in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 11-06-2006, 11:41 AM

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