Display both Content of non adjacent cell if one cell value is greater than, other wise don't display

[David gonzalez]

Hi,


please is a guru there that help me on which formula to use on following task?:

B3:B38 Have numbers between 01 to 100, Then on
AC3:AC8 there are Score that belong to each of these numbers.

What i need to achieve is :
(using B3 as example)

If number of B3 have an Score Greater than 7 on AC3,
Then display content of B3 and C3 IN on continuous cells but in other range of the sheet,
Otherwise don't display..


note: i'm already using conditional format (many),and i can't apply it more due to a VBA Code (that i'm using in same range.)


Thank you !

David

 

[onlyadrafter]

Hello,

do you mean this?

=IF(AC3>7,B3&C3,"")

not sure if this is what you are asking for.