+ Reply to Thread
Results 1 to 3 of 3

Multiple if and istext function

Hybrid View

n0cty Multiple if and istext... 05-25-2015, 05:48 AM
TMS Re: Multiple if and istext... 05-25-2015, 05:53 AM
popipipo Re: Multiple if and istext... 05-25-2015, 06:47 AM
  1. #1
    Registered User
    Join Date
    05-25-2015
    Location
    Vaslui, Romania
    MS-Off Ver
    2010
    Posts
    1

    Multiple if and istext function

    Hello,
    I need help with "if" function. I have two sheets. In the second sheet I wanna take data from first sheet with the following condition:
    - if the value from the first sheet cell is greater than 8 than to return the number 8;
    - if the value from the first sheet cell is equal or less then 8 thanto return 8-2;
    - if the value from the first sheet cell is a text then to return the text.
    I tried to use the function:
    =IF(ssb!E5>8;8, if(ssb!e5>=8;ssb!e5-2), if(istext(ssb!e5);ssb!e5))
    but it returns an error.
    Any help will be appreciated.
    Manny tnx.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    48,539

    Re: Multiple if and istext function

    Maybe, untested:

    Formula: copy to clipboard
    =IF(ssb!E5>8;8; if(ssb!e5<=8;ssb!e5-2; if(istext(ssb!e5);ssb!e5;"???"))



    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,676

    Re: Multiple if and istext function

    it returns an error
    =IF(ssb!E5>8;8, if(ssb!e5>=8;ssb!e5-2), if(istext(ssb!e5);ssb!e5))
    You use comma and semicolon in one formula
    That doesn't work, use one of them.
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

+ 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. multiple IF statements with ISTEXT needed
    By ELEMACD in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 07-24-2019, 05:41 PM
  2. [SOLVED] Problem with using istext in a nested IF function
    By Ciarmccabe in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-09-2013, 06:30 PM
  3. ISTEXT or SEARCH function with 2 variables
    By mobycane in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-08-2010, 04:49 AM
  4. ISTEXT function
    By cordin4 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-18-2008, 08:21 AM
  5. Sumproduct Or Istext Function Problem
    By andyp161 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-04-2007, 12:28 PM

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