- You are here
- Microsoft Newsgroups Archived.At
- microsoft.public.excel.misc
- 2003 October
- Zeros in worksheet

Subject: | Zeros in worksheet |

Posted by: | DrBryanJ (DrBrya…@optonline.net) |

Date: | Wed, 8 Oct 2003 |

I am creating a work book to look at scores of a soccer

tournament. I created a function to look at the scores

and assign points to each team. This is the function: =IF

(G12="-",0,IF(G12>H12,3,IF(G12=H12,1,0))) The function

looks at the score of the soccer game and determines the

number of points a team recieves toward their standings

in the tournament. It should return a value of 3 if Team

g wins the game, a value of 1 if there is a tie and a

value of 0 if team h wins. The first part g12="-" works

fine it returns a value of 0 when no score is entered

yet. It is the G12>H12 that is the problem. When I type

a score of 0 - 3 the worksheet chenges the 0 to text form

zero. When the function looks at the binary values it

sees zero as greater than 1 and returns a value of 3

instead of 0.

I need the cell that I enter the score into to display

the number 0 instead of the text zero.

I thought it was a simple format option, but none of the

number formats seem to help.

- Re: Zeros in worksheet posted by Frank Isaacs on Wed, 8 Oct 2003
- Re: Zeros in worksheet posted by Paul on Wed, 8 Oct 2003