What if function

**Newman100** · 02-07-2009, 08:23 AM

I made a grid of fixtures for a football leauge and then i made a table for the the amount of points each team has but i cant get the points table to automatically update. I want the table to give a team 3 points when they score more goals than the other team. I just cant seem to use the what if function correctly.

**DonkeyOte** · 02-07-2009, 08:29 AM

Please post a sample of your file.

**Newman100** · 02-07-2009, 08:47 AM

ok will do its very simple has no real teams or scores in it yet.

**DonkeyOte** · 02-07-2009, 09:08 AM

using this type of layout will make your life a little complex... see if the attached helps...

on an aside - when loading samples it's best to ensure they're in 97-03 format as not everyone has 2007 as yet.

**Newman100** · 02-07-2009, 09:43 AM

That is extremly helpful thank you for that, sorry bout that 2007 format i prefer the older one just got a new laptop and thats what came with it.

**DonkeyOte** · 02-07-2009, 09:51 AM

I'm glad it helped.

FYI, when you save a file you can pick the file format, so you can choose to save as 97-2003 format even if running in 2007 -- doing so will generate the file with the traditional .xls extension. The 2007 file types have better compression etc so files in older formats (binary) will be bigger than the same file saved as a 2007 file, however, for purposes of samples etc the .xls type is preferable.

Cheers