if and then

[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

 

[Mike H]

Try this

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

Mike

 

[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

 

[lawre]

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

 

[lawre]

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

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

 

[lawre]

Try this

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

Mike

Hi Mike H

I've tried them it works.

Thank you very much for the answers.

Regards

lawre