if and then

L

lawre

Cell c10=typed text "call" or Cell c10=typed text"put"

1. If cell c10=call, then the default cell = high, how to set this up

2. If cell c10=put, then the default cell=high, how to set this up;

3. If cell c10=call, then default cell=cell b15*105%; and

4. Iff cell c10=put, then default cell=cell b15 *95%

Would appereciate the forumers could show me hoe to set them up.

Thank you
 
G

Gord Dibben

What would be the "default cell"?

You have too many conditions to do this all in one cell.

i.e. "call" cannot return two different values in same cell so you need a
minimum of two formula cells.

=IF(OR(C10="put",(C10="call")),"high") entered in A1

=IF(C10="call",B15*1.05,IF(C10="put",B15*0.95)) entered in A2

Also............why should "call" or "put" both return "high"?

A typo maybe?


Gord Dibben MS Excel MVP
 
L

lawre

Gord Dibben said:
What would be the "default cell"?

You have too many conditions to do this all in one cell.

i.e. "call" cannot return two different values in same cell so you need a
minimum of two formula cells.

=IF(OR(C10="put",(C10="call")),"high") entered in A1

=IF(C10="call",B15*1.05,IF(C10="put",B15*0.95)) entered in A2

Also............why should "call" or "put" both return "high"?

A typo maybe?


Gord Dibben MS Excel MVP
Click to expand...
 
L

lawre

Gord Dibben said:
What would be the "default cell"?

You have too many conditions to do this all in one cell.

i.e. "call" cannot return two different values in same cell so you need a
minimum of two formula cells.

=IF(OR(C10="put",(C10="call")),"high") entered in A1

=IF(C10="call",B15*1.05,IF(C10="put",B15*0.95)) entered in A2

Also............why should "call" or "put" both return "high"?

A typo maybe?


Gord Dibben MS Excel MVP



Hi Gord
Click to expand...

I,m actually referring to two default cells item 1 & 2 relates to one
default cell and items 3 & 4 relates to another default cells.

I,ve got the answers i wanted which is a little difference from Mike H.

Thank you

Regards

Lawre
 
L

lawre

Mike H said:
Try this

=IF(C10="Call",B15*1.05,IF(C10="Put",B15*0.95,""))

Mike
Click to expand...


Hi Mike H

I've tried them it works.

Thank you very much for the answers.

Regards

lawre
 
Top