Ulrich
04-03-2001, 08:57 PM
I need to add three expressions I have built but I don't know how.
[pull ups]*5
[sit ups]
Here is where the problem is the next expression isn't and expression but a simple and long "if this is enterd show this"
=switch([run time]<1800,"100"
[run time]between 1801 and 1810,"99"
[run time]between 1811 and 1820,"98"
....
all at that interval until
[run time]between 3401 and 3430,"3"
[run time]between 3431 and 3500,"2"
[run time]between 3501 and 3600,"1"
[run time]>3600,"0")
So now how do I add all these three expressions together to get and answere? adding sit ups and pull ups is easy but getting the run time into the equations is what I can't figure out.
[pull ups]*5
[sit ups]
Here is where the problem is the next expression isn't and expression but a simple and long "if this is enterd show this"
=switch([run time]<1800,"100"
[run time]between 1801 and 1810,"99"
[run time]between 1811 and 1820,"98"
....
all at that interval until
[run time]between 3401 and 3430,"3"
[run time]between 3431 and 3500,"2"
[run time]between 3501 and 3600,"1"
[run time]>3600,"0")
So now how do I add all these three expressions together to get and answere? adding sit ups and pull ups is easy but getting the run time into the equations is what I can't figure out.