Results 1 to 5 of 5
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Formula Problem (Excel 2002)

    Hi


    I have a formula in cell F22 in Worsheet "Input" the cell appears to be empty visually, if the formula is not activated, I would like put in the cell containing the formula below , Unison G if the cell is not actived but if it is activated then I would like to see the result of the formula.

    Ive tried ISNONTEXT, ISBLANK bu can't get a result.


    =IF(ISNONTEXT(Input!$F$22),"Unison G","")

    Many Thanks

    Braddy
    If you are a fool at forty, you will always be a fool

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula Problem (Excel 2002)

    I do not understand what you are trying to do. What do you mean by "if the formula is not activated?" Are you saying that you only want to display something in the cell if the cell is selected, and if the cell is not selected you want to display the text "Unison G"? Is the formula you want to display the result of in cell F22? What cell do you want to display "Unison G" or the formula result in?
    Legare Coleman

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Formula Problem (Excel 2002)

    Hi Legare

    Cell F22 contains =IF(J20="Autodosed Powder","",IF(J20="Manual Powder","",IF(J20="Manual Tablets","",IF(J20="DIFY Tablets","",IF(ISNA(VLOOKUP(H20,Manufacturer,2,0)) ,"",VLOOKUP(H20,Manufacturer,2,0)))))) If J20 contains other than Autodosed Powder or Manual Powder, etc then the cell is empty so in my formula I would like to see Unison G.

    However if J20 does contains ie Autodosed powder, F22 will contain Integral Pump Therefore I would like see this in my formula cell.

    I hope this is clearer.

    Thank you for your patience
    Braddy
    If you are a fool at forty, you will always be a fool

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Formula Problem (Excel 2002)

    Does this do what you want?

    =IF(F22="","Unison G",F22)
    Legare Coleman

  5. #5
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Formula Problem (Excel 2002)

    Hi Legare

    That worked fine with a slight modification because F22 is a on a different sheet to the formula.

    Thanks for your assistance.

    Braddy
    If you are a fool at forty, you will always be a fool

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •