+ Reply to Thread
Results 1 to 3 of 3

if function returning false instead of my selection

  1. 10-27-2006, 03:01 PM #1
    kelleybr
    kelleybr is offline
    Registered User
    Join Date
    10-24-2003
    Location
    Washington
    MS-Off Ver
    2003
    Posts
    6

    if function returning false instead of my selection

    =IF(E3<50001,"<$50K", IF(E3>50001<300000,"$50-$300K"))

    with this calculation if E3 is $49000, it's returning >$50K like it's supposed to. But when E3 is 250000 it's returning False, instead of $50-$300K. It's probably something simple, but i'm stuck.
    Reply With QuoteRegister To Reply
  2. 10-27-2006, 03:12 PM #2
    VBA Noob
    VBA Noob is offline
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Try

    =IF(ISBLANK(E3),"",IF(E3<50001,"<$50K",IF(E3<=300000,"$50-$300K","")))

    VBA Noob
    Reply With QuoteRegister To Reply
  3. 10-27-2006, 03:23 PM #3
    kelleybr
    kelleybr is offline
    Registered User
    Join Date
    10-24-2003
    Location
    Washington
    MS-Off Ver
    2003
    Posts
    6
    That worked, thank you very much.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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