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.

 

[Scott Huish]

=if(sp.d<>0,if(la.d<>0,385,if(la.o<>0,685,0)),0)

 

[hellebore08]

Try this and tell me if it works..

=if(not(AND(SP.D<=0,LA.D<=0)),385,if(not(and(SP.O<=0,LA.O<=0)),685,0))

cheers!

-e.rgabrieldoronila