PDA

View Full Version : Scoreboard


patf
02-18-2008, 10:31 AM
Need some help, please. I have created a "scoreboard" to type in and project results of a contest. I've used input fields for each category (1A, 1B, 1C, etc) and an input field to total these (1Total). I've tried to get the 1Total field to total 1A+1B+C, etc. but can't figure out how.

Any assistance is greatly appreciated.

Thanks.

mindstitchdr
02-18-2008, 11:06 AM
Is this what you are trying to achieve?

patf
02-18-2008, 11:26 AM
Exactly! With the total being the sum of numbers in the input fields.

mindstitchdr
02-18-2008, 11:30 AM
Cool, glad I could help.

patf
02-18-2008, 11:38 AM
Mindstitchdr, the total field doesn't display/calculate the other fields. That's what I need to do. (I thought you were asking a format question.) How can I caculate and display the total when I input numbers into the input fields?

Thanks.

mindstitchdr
02-18-2008, 02:05 PM
OK. On my example if you enter a number in the first field, then the second, then the third, then the fourth, then you hit the text Total it will add the numbers from all four inputs and display the results in the fifth input box. Is this not what you needed?

patf
02-18-2008, 02:11 PM
My bad - didn't know to press the text Total.

Thank you! I truly apreciate it.

mindstitchdr
02-18-2008, 02:24 PM
No problem. I should have used a button instead. :o

longedge
02-19-2008, 03:13 AM
You can do the same sort of thing without having to click for a total so you get a constantly updated total as you enter or delete numbers. Just another approach.

patf
02-19-2008, 09:00 AM
Thanks, Longedge, with your help and with Mindstitchdr's I have a perfect solution.

I truly appreciate the help of the experts. It's the great thing about this forum.

DaSoulRed
02-19-2008, 09:19 AM
Jalow, Duds.

So to use numeric basic operations like those i try with the file uploaded by mindstitchdr.

i mean it is there any how to use symbols to replace the + and use beside - or / that way it will be a nice way to do an excel project formula.

any direction will be great :huh

longedge
02-19-2008, 10:44 AM
i mean it is there any how to use symbols to replace the + and use beside

If I understand you correctly then something like this example.

patf
02-19-2008, 12:03 PM
Thanks to all who helped on this. Here's a "generic" (non-client specific) version for anyone who can use it.

DaSoulRed
02-19-2008, 12:49 PM
If I understand you correctly then something like this example.

Look Here i upload something it is plain simple example on what i am trying to reach.

Remember it is not what is, it is how do you use it. :wow

DaSoulRed
02-19-2008, 01:10 PM
If I understand you correctly then something like this example.

Look Here i upload something it is plain simple example on what i am trying to reach.

Remember it is not what is, it is how do you use it. :wow

DaSoulRed
02-19-2008, 01:22 PM
i wose thinking about my old days back at high school socoring and i am not talking about basquetball

well nice o have some moments back on my mind.

and if you ask me yes it wose a nice tieme there. :)

DaSoulRed
02-19-2008, 02:19 PM
Here it Goes just trying to do a template with seven inputs in diferent places off the project so the results will be the total of all this inputs.

kind a way for the user to recibe a price with out us and that way himself can get the TOTAL using the simple formula added in the inputs with operations like +, -, /, etc.

so the rigth question is how to use input boxes to get total using basic operations like +, -, /

Thanks :)