if and then
 

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

if and then
 

Try this

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

Mike

"lawre" wrote:


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

if and then
 

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

On Sat, 24 May 2008 00:14:01 -0700, lawre
wrote:


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

if and then
 

"Gord Dibben" wrote:

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

On Sat, 24 May 2008 00:14:01 -0700, lawre
wrote:


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

if and then
 

"Gord Dibben" wrote:

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

On Sat, 24 May 2008 00:14:01 -0700, lawre
wrote:


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

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

if and then
 

"Mike H" wrote:

Try this

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

Mike

"lawre" wrote:


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


Hi Mike H

I've tried them it works.

Thank you very much for the answers.

Regards

lawre