# Thread: Formula Problem (Excel 2002)

1. ## 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

2. ## 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?

3. ## 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.

4. ## Re: Formula Problem (Excel 2002)

Does this do what you want?

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

5. ## 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.

#### Posting Permissions

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