Sport results worksheet

[artzii]

Hi!

Im make worksheet for sport. And I have some question:

I make formula which count points in a result which is in another cell then points like
A1 result
A2 points

But if I have to put A1-cell DNS or DNF then A2 show ######
Which kind of formula I should but in A2 cell so there is no #####, only 0.

[ratcat]

G'day and welcome to the forum,

Try this

=IF(OR(A1="DNS",A1="DNF",A1=""),0,Insert your original formula here)

Remember if you copy and paste the formula above you may have to change the " , " with " ; " to make the formula work.

Cheers

RC