+ Reply to Thread
Results 1 to 6 of 6

cell dependant on other cells

  1. #1
    Forum Contributor
    Join Date
    03-23-2010
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    153

    cell dependant on other cells

    hi guys

    i have an issue that i cannot get my head round

    in cell H15 i have this
    Please Login or Register  to view this content.
    but what i need to do is i cell H5 has the phrase "with survey" in it i want it to read different

    for example

    D26 = sfk69 (4)(5) sfk 70 (4)
    H4 = 5-7 weeks
    H14 is dependant on whats in m14 but will read something like "( 03/12 - 17/12 )

    so if cell H5 has supply only in it i would like it to read
    sfk69 (4)(5) sfk 70 (4) 5-7 weeks ( 03/12 - 17/12 )

    however if cell H5 has the phrase "with survey" in it i would like it to read
    sfk69 (4)(5) sfk 70 (4) 5-7 weeks AFTER SURVEY

    is this possible
    regards
    Last edited by sdts; 12-30-2010 at 07:14 AM.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: cell dependant on other cells

    Perhaps simply:

    Please Login or Register  to view this content.

  3. #3
    Forum Expert Domski's Avatar
    Join Date
    12-14-2009
    Location
    A galaxy far, far away
    MS-Off Ver
    Darth Office 2010
    Posts
    3,950

    Re: cell dependant on other cells

    Try:

    =D26&" "&H4&" "&IF(H5="with survey","after survey",H14)

    Dom
    "May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."

    Use code tags when posting your VBA code: [code] Your code here [/code]

    Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.

  4. #4
    Forum Contributor
    Join Date
    03-23-2010
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    153

    Re: cell dependant on other cells

    hi guys

    thanks for your replies
    i cant seem to get that to work
    maybe i should be more specific than say wit the phrase" with survey"

    the possibilities are :-

    Supply Only No Survey
    Supply Only With Survey
    Supply Only Account
    House Sale - remedial
    Supply & Fit
    Supply & Fit With IWA
    Supply & Fit With Survey
    Supply & Fit With Survey & IWA
    Supply & Fit Account

  5. #5
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: cell dependant on other cells

    Yes, specifics generally help.

    Please Login or Register  to view this content.
    If you were to detail all the various options for H5 the above could perhaps be streamlined

  6. #6
    Forum Contributor
    Join Date
    03-23-2010
    Location
    england
    MS-Off Ver
    Excel 2007
    Posts
    153

    Re: cell dependant on other cells

    fantastic donkeyote
    tanks so much

+ Reply to Thread

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