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