Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|