Study and help :If Statement

[karobonas]

Hi,

I am unsure if I need to use the IF Statement for the following:

If Row 27 contains data and column T27 has a number greater than 1 then I would like another cell (B14) to display the data in B27

I would like this to work for multiple rows of data.

Any assistance is much appreciated!

Regards,

Karo

[teylyn]

Hello Karo,

this would be easier to solve with your original workbook.

T27 is not a column, it's a cell address.
What kind of data are you checking for in row 27? Text? Numbers?
Which cells in row 27 do you want to check? If T27 is greater than 1, then row 27 does contain data, so "if row 27 contains data" is really obsolete.

Try in B14:

=if(T27>1,B27,"")

If that does not help, please post your workbook.

cheers,

[karobonas]

Hi,

Please find attached my original WB.

As you can see, I have "Text" displayed in Column B and Numbers (based on a calcualtion) in Column T. I would like Column B14 and consecutive cells (depending on results) to display the text in Column B IF any number in the adjacent Column T is greater than 1.0.

As an example using the WB attached. Column B14 should display the Text in Column B53 and B54 because T53 and T54 have numbers greater than 1.0

Hope this clarifies a bit better.

[karobonas]

Hi,

Does anyone have any update on this? Would I need to use some code of somesort?