Very Basic Question From New Guy

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!!!!

Hi, Welcome to the forum,

You mean this ?

Formula:

Please Login or Register  to view this content.

Hi Welcome to this forum..
More exact version...
Try this...

Please Login or Register  to view this content.

Nick, welcome to the forum

Im happy you got the answer you were looking for

However for future reference, please take a look at the forum rules (specifically rule #1, regarding thread titles) before making your next thread