Excel string help
 

I am trying to design a target betting programme, i need to put a string in E13 that does this.

if h12 = 0 then 10+G12+e12 (i can do this bit)

BUT,

if h12 (win div paid) has a figure above 0, i need to have e13 be 10 (back to start) i keep getting false error in the box

anyone who can help would be great.

anyone who wants a copy when its finished let me know, its free.

Cheers D

=IF(H12=0,10+G12+E12,10)

You've left out the false part of the statement if I'm reading it right, that's why you get the false error. The above calc should fix it if I've got your idea right.

It reads like this =IF(TRUE, THEN DO THIS,OTHERWISE (FALSE) DO THIS)

=if(h12=0,10,h12)

I think this is what you are after if i understand correctly

The formula is saying if h12 = 0 then h12 = 10 otherwise it = h12

We are on the same parth Chrome but i find it hard to put in formulas with out seing the results.

Thank you
 

Your not bad you lot are you.

Thank you CP, it worked, i know where i went wrong, thanks to you also shaun.

Ill stick it here later when its done, should be a treat.

D

how bout this then
 

I want to have the sheet only show the next row after i "tab"

ie

i have 22 rows.

first bet is in row 1, when that bet is over i put the win div into its spot then hit "tab", how can it then "add" the next row including calculations. If i leave it "open" it looks messy and the calculations are all on the incline waiting for a figure in win div.

I am a bit of a novice but having a go.

D

I don't know of any way to "switch off" a line. If I understand your requirement correctly you would be happy to "hide" only the remaining calculation fields on the page. I am assuming you will still want your future "bet" entries displayed.

This may be a bit cumbersome but IF conditions can be embedded. You could surround each calc field with another IF condition referring to the win cell on the previous line as follows:
assume H11 holds win details (empty if unused "" or numeric if used 0,etc).

IF(H11="","",IF(H12=0,10+G12+E12,10))

other calcs on line 12 would be: IF(H11="","",(other calc)).

As I said, it is cumbersome but will work if unused win cell is empty. And once you have completed one line you copy the rest. The only wrong 'un of course would be the first line which cannot refer to the previous line.

Hope it helps.

Thanks see dee (that will be be in an hour)

I have decided to forget that bit, thanks for your help anyway.

I am going to do a differant thing and just put a carry over figure from 1 sheet to the 2nd.

Cheers and thanks
D

"I am a bit of a novice but having a go."
your not the only one dingoboy

I have one which I'm having trouble with

See if I can explain it
D2 price layed @
E2 price backed @
F2 the amount $
G2 amount win / Loss
H2 place horse came
now what I want to do if the horse doesn't place 1st 2nd or 3rd G2 to show 0 if it did place then G2 to show profit/loss ( F2*E2-(D2*F2))

I came up with something like this =IF("H2">4,F2*E2-(D2*F2),"H2"<4) played around for a while but cant get

Thanks

Try This
 

looks a bit untidy but will do the job

=IF(H2 =1,X1,IF(H2 =2,X1,IF(H2 =3,X1,0)))

Where X1 is the cell containing your Profit /loss Formula