If statement with multiple cells

[canam]

Hello

I am trying to write an if statement that uses several posibilities in one statement. Example: =If(E56=(G1:G5),(a1*12),If(E56=(G6:G10,(b1=B8*4)))). This doesn't work even if I list the range as (G1,G2,G3,G4,G5). It tells me there are too many arguments. In my actual sheet my range of values is much larger than G1:G5. Is there any way to get this done? :x Thanks

 

[NBVC]

You may solve your problem with Match of Vlookup statements,

ie. If(Vlookup(E56,G1:G5,False),value if true, value if false).


Try posting an example if this doesn't do it for you.

 

[just_jon]

Hello

I am trying to write an if statement that uses several posibilities in one statement. Example: =If(E56=(G1:G5),(a1*12),If(E56=(G6:G10,(b1=B8*4)))). This doesn't work even if I list the range as (G1,G2,G3,G4,G5). It tells me there are too many arguments. In my actual sheet my range of values is much larger than G1:G5. Is there any way to get this done? :x Thanks

Your intent is a bit unclear, but guessing at

=IF(ISNUMBER(MATCH(E56,G1:G5,0)),A1*12,IF(ISNUMBER(MATCH(E56,G6:G10,0)),B8*4,"Not in either range."))

 

[BrianB]

We cannot compare a single cell with multiple cells directly. Need to use functions.

This is one way. You will need to turn your logic round because this depends on the value not being found in the range :-

=IF(ISERROR(VLOOKUP(E56,G1:G5,1,FALSE)),1,0)

 

[canam]

just jon I used your suggestion and it works perfeclty. Thank you all for the help.