+ Reply to Thread
Results 1 to 3 of 3

IF Formula

  1. #1
    Forum Contributor
    Join Date
    03-20-2013
    Location
    Manchester
    MS-Off Ver
    Excel 2010
    Posts
    200

    IF Formula

    IF Formula.


    Hello

    Please could someone assist

    C1 and D2 are linked cells

    if
    C1 has a value, and D1 doesnt, then my formula in C2 should read C1 & " x Cases"
    If
    D1 has a value and C1 doesnt, then my formula in c2 should read D1 & "x Spilts"

    now here is where im stuck

    if C1 has a value and D1 has a value, then my formula in C2 should read, C1 & " x Cases" & D1 & " x Spilts"

    if C1 has no value, and D1 has no value, then blank

    thanks in advance

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,076

    Re: IF Formula

    Isn't this simply...

    in C2
    =IF(C1<>"",C1&" x Cases","")&IF(D1<>"",D1&" x Spilts","")
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,454

    Re: IF Formula

    =IF(AND(C1<>"",D1<>""),C1 & " x Cases " & D1 & " x Spilts",IF(AND(C1<>"",D1=""),C1 & " x Cases",IF(AND(C1="",D1<>""),D1 & "x Spilts","")))
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

+ 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. Replies: 11
    Last Post: 06-06-2014, 03:34 PM
  2. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 04:06 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