If statements

[ak8c]

I hope someone can help me with this. I am trying to actually put 2 different arguments into one cell. Here is the example; =if(SP.D<=0,LA.D<=0,0,385) and =if(SP.O<=0,LA.O<=0,0,685) how can i combine them to make one argument.

Any help is appreciated.

 

[kpark91]

The above formulas have too many arguments so they are not valid.

If you want to print 1 when SP.D <= 0 AND LA.D <= 0 Then
print 0 SP.D > 0 AND LA.D <= 0 Then
print -1 SP.D <= 0 AND LA.D > 0 Then

=IF(SP.D <= 0, IF(LA.D <= 0, 1, -1), 0)

 

[crook_101]

Hi,

Welcome to the board.

For if statements we really need the cell references involved to provide an answer are the "SP.O" & the "SP.D" contained in the same cell/range.

If you can post a bit more detail, you will get a response, can you post any of your data??

Ian

 

[Scott Huish]

=if(and(sp.d<=0,la.d<=0),0,385)

 

[texasalynn]

Welcome to MrExcel board....

like this

=IF(AND(SP.D<=0,LA.D<=0),0,385)

 

[kpark91]

There are other operators such as
XOR
OR
AND

Type in MS Office help to use these functions.

 

[ak8c]

OK someone suggested that I give more info so here it goes.
What I am trying to do is the two arguments are valid separately, but I need them to return different values if false for the different cell names.

SP.D,LA.D,SP.O, and LA.O are the cell names. SP.D and LA.D need to = 385 if the value is not 0 and SP.O and LA.O needs to = 685 if not 0.

I hope I have explained what I am trying to do better. Please let me know if I have or just confused everyone more.

 

[texasalynn]

maybe this

=IF(AND(SP.D<>0,LA.D<>0),385,IF(AND(SP.O<>0,LA.O<>0),685,0))

 

[Scott Huish]

There are other operators such as
XOR
OR
AND

XOR does not exist in the spreadsheet, only in VBA.

 

[kpark91]

XOR does not exist in the spreadsheet, only in VBA.

Ahh thank you