Help with an If statement

[Steve Cohen]

I'm looking for an if statement or something that will look at the text
entries in Column G and if it says Risking take the dollar amount that
follows Risking and enter it in the same Row in Column A and if it say To
Win take the dollar amount that follows To Win and enter it in the same Row
in Column B.

EX...Minnesota Wild/Philadelphia Flyers 11/20/2003 7:35:01 PM - EST Total
Points UNDER 4½ +110 for Game Risking 200.00 To Win 220.00

In this example the 200.00 following Risking would be entered in A37 and the
220.00 following To Win would be entered in B37 .

I came got some help and came up with the following.

A37 enter

=IF(ISERROR(SEARCH("risking",$G37)),"",MID(G37,SEARCH("risking",$G37)+8,SEAR
CH("to win",$G37)-SEARCH("risking",$G37)-8))

B37 enter

=LEFT(C37,FIND(" ",C37))

and C37 enter

=MID(G37,SEARCH("to win",$G37)+7,LEN(G37))

This works great, but the only thing is that if there is no value in G37
then both B37 & C37 have a #VALUE in them.

I know that adding a " " would take care of this, but I'm not sure were it
would go.

Thanks

Steve

 

[Alan]

Try
=IF(G37<>0,0,IF(ISERROR(SEARCH("risking",$G37)),"",MID(G37,SEARCH("risking",
$G37)+8,SEAR
CH("to win",$G37)-SEARCH("risking",$G37)-8)))

or

=IF(G37<>"","",IF(ISERROR(SEARCH("risking",$G37)),"",MID(G37,SEARCH("risking
",$G37)+8,SEAR
CH("to win",$G37)-SEARCH("risking",$G37)-8)))

Regards,
Alan.