If statement help

[Jazzer]

Hi All,

Could somebody please provide me with the correct formula for the following

Basically

if New_Data!D8 = R I want New_Trades!B13 to = Repo
if New_Data!D8 = Q I want New_Trades!B13 to = Reverse Repo
if New_Data!D8 = T I want New_Trades!B13 to = Outright Purchase
if New_Data!D8 = U I want New_Trades!B13 to = Outright Sale

Many Thanks
James

 

[Jonmo1]

Is it just those two criteria?
R=Repo
Q=Reverse Repo

Or will it go on for more possiblities, like
T=Text3
S=Text4
Etc?

what result do you want if it doesn't equal either option? A blank?

 

[VoG]

Try
=IF(New_Data!D8="R","Repo",IF(New_Data!D8="Q","Reverse repo",""))

 

[Jazzer]

just the 4 criteria (mentioned above - edited my original post from 2)

if blank then I would happy with 0 as the result

 

[VoG]

Try

=LOOKUP(New_Data!D8,{"R","Q","T","U"},{"Repo","Reverse repo","Outright purchase","Outright sale"})