IF "2" THEN DISPLAY "6000 CYCLES" ? help

[mattyj]

Yet another question from a beginner

I have a field set up with a drop down window for an anticipated life for a battery in years e.g. "2" "8"

but I want a second field to automatically fill its self in when you select 2 or 8 I want the second field to automatically say 6000 or 21000 cycles depending on the time chosen.

Am I way in over my head? Should I be thinking of a more simple way to do this?

[Slobey]

make the cycle field a calc:

case(

yearfield = "2"; 6000;

yearfield = "8"; 21000

)

[Lee Smith]

Slobey has provided a calculation that will do what you request, it can be shorten if you are only having the two choices (i.e. 2 or 8) to:

case(

yearfield = 2; 6000; 21000

)

BTW, you don't have to put quotes around a number in a calculation.

Lee