Constants In Formulae
 

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

Constants In Formulae
 

Hi Barty.

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

regards,
driller
--
*****
birds of the same feather flock together..



"Barty" wrote:

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

Constants In Formulae
 

Try:

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

--
HTH

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


with @tiscali.co.uk


"Barty" wrote in message
...
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

Constants In Formulae
 

Cheers

Constants In Formulae
 

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

SORRY

"driller" wrote:

Hi Barty.

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

regards,
driller
--
*****
birds of the same feather flock together..



"Barty" wrote:

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

Constants In Formulae
 

That hit the nail on the head

"Sandy Mann" wrote:

Try:

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

--
HTH

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


with @tiscali.co.uk


"Barty" wrote in message
...
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

Constants In Formulae
 

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

--
*****
birds of the same feather flock together..



"Barty" wrote:

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

SORRY

"driller" wrote:

Hi Barty.

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

regards,
driller
--
*****
birds of the same feather flock together..



"Barty" wrote:

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

Constants In Formulae
 

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


with @tiscali.co.uk


"Barty" wrote in message
...
That hit the nail on the head

"Sandy Mann" wrote:

Try:

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

--
HTH

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


with @tiscali.co.uk


"Barty" wrote in message
...
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

Constants In Formulae
 

Hi Sandy Mann,

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

regards,
driller
--
*****
birds of the same feather flock together..



"Sandy Mann" wrote:

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


with @tiscali.co.uk


"Barty" wrote in message
...
That hit the nail on the head

"Sandy Mann" wrote:

Try:

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

--
HTH

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


with @tiscali.co.uk


"Barty" wrote in message
...
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