R1C1 Calculation - Syntax Help Required

Hi,

This is my first post so be gentle with me!

What I'm trying to do is to perform a calculation in all populated cells in column AS.

I want to check cell AD for a value of 27. If is exists I then want to use the minimum value found in either cell I or U then multiply it by the value in cell AC as a percentage.

I'm using the code below but there's an error somewhere - if I type in the formula =IF(AD2=27,(MIN(I2,U2))*AC2%,"") it works. Any idea where I'm going wrong?

Range("AS2").Select
Range("AS2:AS" & lastrow).FormulaR1C1 = "=IF(RC[-15]=27,MIN(RC[-36],RC[-24])*RC[-16]%,””)

Thanks!

CK76 - worked a treat!

Thank you so much

You are welcome

If your question is resolved, please mark the thread as solved by using Thread tools found at top of your initial post.