Constants In Formulae

[Barty]

How do i get the constants in a formula to change when i fill down
EG
=if(as18=18,a18,"") in cell X
=if(as19=19,a19,"") in cell Y

 

[driller]

Hi Barty.

EG
=if(as18=ROW(AS18),a18,"") in cell X
=if(as19=ROW(AS19),a19,"") in cell Y

regards,
driller

 

[Sandy Mann]

Try:

=IF(AS18=ROW(A18),A18,"")

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
[email protected] with @tiscali.co.uk

 

[Barty]

Cheers

 

[Barty]

Not to put a downer on it but i need them to stay as constants so 18,19,20ect

SORRY

 

[Barty]

That hit the nail on the head

Try:

=IF(AS18=ROW(A18),A18,"")

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
[email protected] with @tiscali.co.uk

 

[driller]

Not to put a downer on it but i need them to stay as constants so 18,19,20ect

SORRY

For what reason you're sorry?

regards,
driller

 

[Sandy Mann]

I'm glad of that but I don't see any substantial difference between mine and
driller's answers

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
[email protected] with @tiscali.co.uk

 

[driller]

Hi Sandy Mann,

Based from the requested HELP infos, i don't know who's head was hit !

regards,
driller