setting a constant in a formula

[Paul15]

dear all,

I have the following the following formula

=IF(AJ3>FORMULAS!$D2,"Yes","No")

I wish to be able to drag this down in my spreadsheet, where $D2 remains a constant. the other value (AJ3 can increment by 1 per line .

Any help please

Paul

 

[GWteB]

Try

=IF(AJ3>FORMULAS!$D$2,"Yes","No")

 

[Paul15]

Try

=IF(AJ3>FORMULAS!$D$2,"Yes","No")

Awesome. thanks

Paul

 

[GWteB]

You are welcome!