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
|