Hi!

I have a table (4x4). It looks something like

A1 = x B1 = 40 C1 = 0.5
A2 = "" B2 = 50 C2 = 0.7
A3 = "" B3 = 60 C3 = 0.9
A4 = 1

A4 gets calculated by looking at which of A1 to A3 that has a "x" in
it. As you can se here, A1 has a "x" in it, thereby A4 gets the value
1.

Now, in D1 I want to do something like

D1 =B&A4*C&A4
in other words,
D1 =B1*C1

This may look stupid here but I need it for something bigger ;):p

The way I'm trying now doesn't work. It gives me a "#Name?"-error
(invalid name (or something like that. I'm running the Swedish version
here ;D)).

If you need any more info, just tell me :)

Thanks!

Best regards,
wally

PS. I wasn't sure where to put this but I'm guessing this is the right
one :D DS.




--
wally_91