+ Reply to Thread
Results 1 to 2 of 2

nested if statements

  1. #1
    Registered User
    Join Date
    06-03-2013
    Location
    Australia
    MS-Off Ver
    Excel 2003
    Posts
    1

    nested if statements

    Hello

    I am struggling to write a nested IF statement

    I have a column of % weight losses and need to report:

    >5% weight loss, (weight loss >5%)
    weight loss but <5% (weight loss >0 and <5)
    weight stayed the same (weight loss =0)
    weight gained (weight loss<0)

    I am struggling writing the between weight range and to write a statement that incorporates all the options.

    If anyone can help I would appreciate it

  2. #2
    Forum Expert boopathiraja's Avatar
    Join Date
    07-12-2013
    Location
    Coimbatore,TamilNadu, India
    MS-Off Ver
    Excel 2007, 2013, 2016, 365
    Posts
    1,455

    Re: nested if statements

    Hi, Try this

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Click just below left if it helps, Boo?ath?

+ 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. [SOLVED] Nested if statements containing multiple and statements
    By John M. in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-22-2014, 11:48 PM
  2. questions with if statements and nested if statements
    By Pat Excel in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 02-03-2013, 01:41 PM
  3. Multiple nested IF statements and AND statements
    By TonyGetz in forum Excel General
    Replies: 2
    Last Post: 12-14-2010, 03:07 AM
  4. Nested If statements / logic statements
    By Brainless_09 in forum Excel General
    Replies: 3
    Last Post: 06-17-2009, 02:59 PM
  5. Replies: 12
    Last Post: 05-15-2009, 08:38 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