IF - formula help

[metropical]

If B# contains but not equal to "expire", then R# = C# x .75/100.
If B# contains but not equal to "sell" or "buy", then R# = C# x .75/100 x 2.

Please ask for further explanation if needed ......... No doubt.
It's calculating option trade fees.

 

[cstimart]

Put this in cell A2 and copy down...

=IF(B2<>"expire",(C2*0.75)/100,IF(AND(B3<>"buy",B2<>"Sell"),((C2*0.75)/100)*2,0))

Is that what you need?

 

[metropical]

Seems to work on the "expire" side, but the "buy" side comes up half the expected number.

 

[cstimart]

Seems to work on the "expire" side, but the "buy" side comes up half the expected number.

Change the formula to *4,then?

 

[metropical]

Nope, that doesn't do it. Stays at 1/2 the proper result.

 

[cstimart]

Nope, that doesn't do it. Stays at 1/2 the proper result.

You want to change that back and revise the other formula, then.

 

[metropical]

Revise to .......... ?

Should there should be an OR in the 2nd half of the formula?

 

[cstimart]

Are there only expire, buy and sell for the choices?

 

[metropical]

let me clarify some.

The C# is #00.
Perhaps this part of the formulas is what I have illustrated wrong.

IE:
(400 x .75)/100) *2.

 

[metropical]

The actual words are

Expire Long, Expire Short, Buy to Close, Sell to Close.