Very Basic Question From New Guy

[nickscofer]

Hi everyone,

I never use excel, but I'm trying to make a points-based spreadsheet to help me and my girlfriend stick to our work out routine. I'm using Excel 2007.

The basics are if you work out you put a * in a column. Using "=COUNTIF(C20:C26, "*")" I tally the stars and you get 1 point for every workout. I tally these per week with a running total at the top. What I really want to do though is if you only work out once a week, you get 0 points and if you work out 0 times a week you get -1 point.

So I'm just looking for a way to recognize the number (x) in the "Total workouts" column and if x = 1 then display a 0 and if x = 0 then display -1, if not then just display the number as is.

Sorry if this is a stupid question but I've spent the last hour on google with no luck.

Thanks everyone!!!!