If statement help

[Jazzer]

Hi Guys,

I am currently using the following formula's on the New_Trades tab of my worksheet

=New_Data!I13*New_Data!R13/100+New_Data!Q13

&

=New_Data!I13*New_Data!R13/100

what I need to do is combine both of these into the same cell using an if statement which decides which of the above calculations to use based on col b on the New_Trades tab

example

if B13 contains Outright Sale or Outright Purchase use
=New_Data!I13*New_Data!R13/100+New_Data!Q13

if B13 contains Repo or Reverse Repo use
=New_Data!I13*New_Data!R13/100

any help would be much appreciated

Many Thanks
James

 

[jim may]

Why not use"

=IF(Left(B13,8)="Outright",New_Data!I8*New_Data!R8/100+New_Data!Q8,New_Data!I11*New_Data!R11/100)

 

[jim may]

Better.. to use..maybe

=IF(Left(B13,8)="Outright",New_Data!I8*New_Data!R8/100+New_Data!Q8,IF(Find(B13,"Repo")>0,New_Data!I11*New_Data!R11/100,""))

 

[Jazzer]

Thanks Jim... that is great.