Another Formula with Multiple Conditions

[gidget424]

I need help with a formula that has several conditions. I can't seem to get it to work. The conditions are:

IF(UPPER(B41)="x"
IF(S8:S13="x",0,"")
IF(C1<=3,C1*C41,"")
IF(C1>=4,45,"")

I keep getting a message that I have too many arguments.

HELP!!!

 

[gidget424]

I have 5 cells in a columns; S8:S13. If any one of these are marked with an "x", and B41 is also marked with an "X", then the amount in the cell that I am entering the formula in should default to 0

 

[colbymack]

that is what I figured, but didn't want to do any more presuming.

How about this:
=IF((B41)="X",IF((VLOOKUP("x",S8:S13,1,FALSE))="x",0,IF(C1<=3,(C1*C41),IF(C1>=4,45," ")))," ")

 

[gidget424]

I'm getting a #N/A message in the cell with the formula in it.

 

[colbymack]

That means that the Vlookup is failing to find the matching X. Try turning this into an If(iserror(vlookup (. . .)),nested if from other arguments, vlookup( . . .)

make sense?

 

[Aladin Akyurek]

I have 5 cells in a columns; S8:S13. If any one of these are marked with an "x", and B41 is also marked with an "X", then the amount in the cell that I am entering the formula in should default to 0

=1-(B41="X")*ISNUMBER(MATCH("X",S8:S13,0))