17th April 2007, 10:40 AM
|
|
Member
|
|
Join Date: Jan 1970
Posts: 4,415
|
|
Quote:
|
Originally Posted by dingoboy
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) |