# Help with linked cell formula

#### Joe Payne

##### New Member
Having problem explaining but I will try. I have linked cells in my workbook that show information! from another cell on a different worksheet in the same workbook. I want to have a conditional formula that will only show the information if there is a number equal to 1 or greater than 1 in another cell. If no number exists, I want the cell showing the info to be blank. I hope I have been able to explain properly.

### Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

#### Domski

##### Well-known Member
Hi,

Welcome to the board.

Does this do what you're after?

=IF(Sheet2!A1>=1,Sheet2!A1,"")

Dom

#### Joe Payne

##### New Member
Thanks, Domski

Thanks, Domski. After getting your formula I used it to research the "if" statement and this is what I finally came up with that worked perfectly.

=IF(Information!F2>=1,Information!A2, 0)

I don't know what the difference between the "" that you added in your statement and the 0 is for the false part of the statement, but it worked.
I now have a better understanding of the "if" statement, thanks to your help.

#### Peter_SSs

##### MrExcel MVP, Moderator
Joe

The difference is, if Information!F2 < 1 then your formula will return a 0 whereas Dom's will return a null string which will make the cell look blank. It just depends what you want to happen.

#### Joe Payne

##### New Member

I understand

Thanks, Peter. I understand the difference.
I want to thank all of the posters who give their time to help people like me who are just entering the world of Excel. Without you guys and gals to give us a helping hand, our learning time would be greatly increased. It is so nice to have a board where the people want to help you instead of trying to beat their own drum and be-little those who ask questions. Thanks again to all.

#### Domski

##### Well-known Member
No worries. I post to learn myself. Still far from being as good as a lot of the guys here but I'm trying .

Dom

#### Peter_SSs

##### MrExcel MVP, Moderator
Re: I understand

Thanks, Peter. I understand the difference.
I want to thank all of the posters who give their time to help people like me who are just entering the world of Excel. Without you guys and gals to give us a helping hand, our learning time would be greatly increased. It is so nice to have a board where the people want to help you instead of trying to beat their own drum and be-little those who ask questions. Thanks again to all.
Thanks Joe
Hope you continue to get satisfaction from using the Mr Excel board

Replies
4
Views
52
Replies
0
Views
39
Replies
3
Views
27
Replies
3
Views
74
Replies
5
Views
94