Ignoring Formulas

[Niall 84]

IS it possible to ignore a formula until it is actually used?

I am making a GAA League table, scoring in GAA is 3 points for a goal
and 1 point for a goal, I was given this formula before in one of
these groups to make this work. (i.e a score of 1-12 in C3 will give
me 15 in D3.

=LEFT(C3,FIND("-",C3)-1)*3+RIGHT(C3,LEN(C3)-FIND("-",C3))*1

The problem is if I am putting in the fixtures for the whole season at
the start of the year obviously the scores will be blank. This leaves
me with a #VALUE! in the cell. and also many #VALUE! in the resultant
league table,

So basically is there anyway of ignoring this formula until there is a
score inserted?

I hope this makes sense, any help would be greatly appreciated.

Thanks,

Niall.

 

[Pete_UK]

Try this:

=IF(C3="","",LEFT(C3,FIND("-",C3)-1)*3+RIGHT(C3,LEN(C3)-
FIND("-",C3))*1)

i.e. if C3 is blank then return a blank, otherwise do the calculation.
You might have other knock-on effects further down the line, though,
but you can use the same approach for other calculations.

Hope this helps.

Pete

 

[Bob Phillips]

=IF(C3="","",LEFT(C3,FIND("-",C3)-1)*3+RIGHT(C3,LEN(C3)-FIND("-",C3))*1)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Niall 84]

Thank you both for your help.

Seems to be working grand now.

Thanks again.

Niall.