Results 1 to 8 of 8

Using If formula, & Formula, and Text in same cell

Threaded View

  1. #1
    Registered User
    Join Date
    04-26-2013
    Location
    Torrance, California
    MS-Off Ver
    Excel 2010
    Posts
    3

    Using If formula, & Formula, and Text in same cell

    Im having serious difficulty doing this please help, if you know.
    I couldnt figure out make the cells look proper so I just attached a picture of the spreadsheet.

    help.jpg



    This is my formula. This is close to what I want but not quite

    =F2&"Dog,"&G2&" Cat, "& H2&" Chicken," &I2& " Pig"

    This shows- 1Dog, Cat, 1 Chicken, Pig

    I want it like this however, if the Cell is blank than I dont want the words to show. I've tried several different formulas and understand it may not be possible in Excel as the program is not a human brain. So the first line I want it to show

    1 Dog, 1 Chicken

    I dont want to see the the Cat or Pig unless there is a number there. Also I want the number related to the cell to be even so the second line I would like it to be

    1 Dog, 2 Cat, 1 Chicken

    If I wasn't clear please let me know, but I dont know how I could explain it better. Only other thing I may be able to do is print screen if necessary. Thank you so much if you can help though.
    Attached Images Attached Images

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