Results 1 to 3 of 3
  1. #1
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post
    Hi,

    I need to put enter in a conditional formula in excel. The formula is based on whether or not the value in F14 is negative or not I have:

    =IIF(F14<1,(F14+F11),(F11-F14))

    I get a ?Name error with it. I've tried enclosing F14 in "" and well as [] but nothing works. What am I missing?

    Thanks,
    Leesha

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    IIf is a VBA function (also used in Access). The equivalent worksheet function in Excel is IF.
    You don't need parentheses around the if-true and if-false parts:

    =IF(F14<1,F14+F11,F11-F14)

  3. #3
    Silver Lounger
    Join Date
    Jan 2002
    Posts
    1,615
    Thanks
    0
    Thanked 1 Time in 1 Post
    Thanks Hans! Worked perfectly!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •