Selecting text

[Cricketer]

The formula =IF(RIGHT(F510,6)="Avenue","Avenue") works fine copying Avenue into L510
The formula =IF(RIGHT(F509,6)="Street","Street") works fine copying Street into L510

But when I put them together I get #VALUE !

=IF(RIGHT(F510,6)="Avenue","Avenue"),IF(RIGHT(F509,6)="Street","Street")

Can someone kindly advise what is wrong

Cricketer

 

[wideboydixon]

=IF(RIGHT(F510,6)="Avenue","Avenue",IF(RIGHT(F509,6)="Street","Street",""))

WBD

 

[Cricketer]

Many thanks Wideboydixon, worked perfectly