Greater than

[esupply]

Morning everyone,

I have a quick question and hopefully get some help
Say i have information From Column A to Z. In cell Z1 I have a margin value, what i want to do is in cell ZZ1 i want the item code that is in A1 to show if the margin value is 20% or higher.... How can i do this?

[NBVC]

You mean?

=IF($Z1>=20%,A1,"")

or

=IF(A1>=$Z1*1.2,A1,"")

[esupply]

Thank you. I put the =sign on the wrong side of the 20%.