formular for mulitpla if's

[tonylpcs@yahoo.co.uk]

Hi Every one,

can someone plase give me the formula for the following, i'm almost there but must be getting something wrong somewhwere?

the formula will go into G6: (i want to put one of the values of the cells into g6 according to whats in g3)

if G3 = 8 then G122 if G3 = 10 then G110, if G3 = 12 THEN G98, if G3 = 14 THEN G84, if G3 = 16 THEN G67, if G3 = 18 THEN G49, if G3 = 20 THEN G28
IF not then ""

please help

thanks

Tony

 

[T. Valko]

Hi Every one,

can someone plase give me the formula for the following, i'm almost there but must be getting something wrong somewhwere?

the formula will go into G6: (i want to put one of the values of the cells into g6 according to whats in g3)

if G3 = 8 then G122 if G3 = 10 then G110, if G3 = 12 THEN G98, if G3 = 14 THEN G84, if G3 = 16 THEN G67, if G3 = 18 THEN G49, if G3 = 20 THEN G28
IF not then ""

please help

thanks

Tony

Try this...

=IF(G3=8,G122,IF(G3=10,G110,IF(G3=12,G98,IF(G3=14,G84,IF(G3=16,G67,IF(G3=18,G49,IF(G3=20,G28,"")))))))

 

[njimack]

=indirect(address(lookup(g8,{8,10,12,14,16,18,20},{122,110,98,84,67,49,28}),7))

 

[jasonb75]

=if(or(g3={8,10,12,14,16,18,20}),choose(g8/2-3,g122,g110,g98,g84,g67,g49,g28),"")

 

[tonylpcs@yahoo.co.uk]

Thank you everyone,

whent with the if formula as i know how to edit that fpr other cells etc

but thank you

Tony