Formula to Check for Data

Hi,

Am trying to create a formula that will check to see if one cell is positive for data and if yes display data from another cell otherwise cell is null.

Where would I begin?

Thanks
Karl

Hi Karl,

without a concrete example, I'll just have to makes something up.

A1 is 77 - a number
B1 is "very old" - a text string

In C1, you can enter a formula that will return the value of B1 if A1 meets a certain criterion. So

=if(A1=55,B1,"")

This will return a blank, since the criterion is not met.

=if(A1=77,B1,"")

This will return "very old", which is the content of B2, because the condition A1=77 is met.

Does that help?

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

it depends.

What is the possible content of E8?

Text? Numbers? Empty? Any combination of these?

And for what condition would you want to return the value in A2? If it is text? If it is not text? If it is a number? If it is not a number?

please specify the requirements.

Fine.

And you'd like to see -- What? -- Where? -- Why?

Please specify and describe your requirements in plain terms and mock up a few expected results.

starting in D2

=IF(ISBLANK(E2),"",A2)

copy down