Working with IF cmd

[Abattage]

Hello.

I'm working on a pricebank for a little company and I need a little help.

Here is a img to explain it. (Some words are in Icelandic, but is dose not matter )

[img=http://img504.imageshack.us/img504/3541/verdbankzj1.th.jpg]

Ok so you can see that there are 4 dialogs that contain prices, (Mel, Harð, Spón and Spraut) and on the far right side I have a box with the same names but only with A,B,C and X.

So my question is, if I put X in R8, then in O8 "=H8*M8" and if I put X in R10, then O8 "=J8*M8" and so on, so I only need to change the X sign from R8-R11 to change to hole price list.

How can I do this with IF, or is there any other more simple way to use this.

Thx
Regards Abattage.

[NBVC]

The image doesn't show where R8, R10, etc are....

It's better if you attach an actual excel sheet to your thread...

Then show example of expected results.

[Abattage]

Sorry for that, here is the excel file.

[Richard Buttrey]

Hi,

It's difficult to be certain of your exact process from the description given, however from my interpretation I'm guessing that the following formula in O8 will give the result you're after, with an x somewhere on R8:R11

=OFFSET(G8,0,MATCH("x",R8:R11))*M8

HTH

[NBVC]

Try, In O8:

Please Login or Register  to view this content.

copied down.

Edit: Eliminated redundancy in column match part of the Index() function....

[Abattage]

This works, just put ; in for ,

=OFFSET(G8,0,MATCH("x",R8:R11))*M8

Worked after I put ; in but I will also try your out NBVC, might work better cus of $$

Thx for all the help guys

[NBVC]

This works, just put ; in for , Worked after I put ; in but I will also try your out NBVC, might work better cus of $$

Thx for all the help guys

I also added an error trap in my formula so that if you don't have any x's in R8:R11, you won't get a bunch of #N/A errors...