Results 1 to 5 of 5

IF Statements

Threaded View

  1. #1
    Registered User
    Join Date
    03-15-2011
    Location
    Guelph, Canada
    MS-Off Ver
    Excel 2003
    Posts
    2

    IF Statements

    Hi All,
    I was directed to this forum as I have an Excel problem. I love Excel and will most definitely make use of this Forum while hopefully helping others. My problem is this...too many arguments for IF statements. This is what I want to do. Hopefully I am sending it correctly:
    If <214.99 but >210 = 210 and If<219.99 but >215 = 215 and If<224.99 but >220 = 220 and If <229.99 but >225 = 225 and If<234.99 but >230 = 230.
    Thanking in advance yet will thank again.

    Glen
    Last edited by Brydgy; 03-15-2011 at 09:19 PM.

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