very simple but cant do it

[Angliojoe]

Hello All,

I need a formula to go in E2 that says if a number is displayed in D2 of 1 or more then display the words from B2 in this cell.

So for example if D2 had a value of 4 and B2 had text in it saying 'Club membership then E2 would contain 'Club membership'.

Thank you all,

Joe.

 

[Jonmo1]

Try

=IF(D2>=1,B2,"")

 

[Angliojoe]

Hi, I tried that but it still displays B2 even if there isnt a number in D2? Im using the newest Excel if that helps?

 

[Angliojoe]

D2 contains a formula that has numbers in it but doesnt display numbers, would that make a difference?

 

[T. Valko]

D2 contains a formula that has numbers in it but doesnt display numbers, would that make a difference?

Yes.

Post the formula that's in D2.

 

[Jonmo1]

OK, so D2 is a formula that returns either a number, or "" right?


You need to test if it's a number as well..

=IF(AND(ISNUMBER(D2),D2>=1),B2,"")

 

[doofusboy]

How about something like this?

=IF(AND(LEN(D2)>0,VAL(D2)>=1),B2,"")

 

[Angliojoe]

Thanks guys, sorted.

Cheers for all your help