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]

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

The actual words are

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

So the "expires": column R would be (400 x .75)/100) *2 or 6
and the "buys": column R would be (400 x .75)/100) or 12 ?

 

[metropical]

So the "expires": column R would be (400 x .75)/100) *2 or 6
and the "buys": column R would be (400 x .75)/100) or 12 ?

7 or 14.

 

[cstimart]

So the "expires": column R would be (400 x .75)/100) *2 or 6

7 or 14.

Then what's the formula for each?

Expire: 400*.75 = 300
300/100 = 3
3*2 = 6

Right?

 

[metropical]

You're right. My brain was in another dimension.
But the formula still isn't working. There must be something else I'm missing or not telling you.

 

[cstimart]

How's this...

=IF(LEFT(B3,6)="expire",C3*0.015,IF(RIGHT(B3,5)="close",C3*0.03,0))

 

[metropical]

Ding Ding Ding!

I took a little liberty with your new formula and edited back to the first ((math)), so I could look at the formula and understand.

=IF(LEFT(B4,6)="expire",(C4*0.75)/100,IF(RIGHT(B4,5)="close",((C4*0.75)/100)*2,0))

So the RIGHT# and LEFT# refer to number of letterS from the right or left of the cell? If the left 6 letters are "expire". If the right 5 letters are "close".

Just curious as to why the 1st didn't work. It looked happy in the Formula pallette, but ......

I've been trying to get here for quite a while. Thanks. Though my math is pretty good and my every day logic, I cannot wrap my head around formulas in Excel.

And, OBTW, great sig. I laughed very hard.

 

[cstimart]

Glad we could figure it out...not sure why the original didn't work, but I'm not a big fan of doing IF <> formulas.