IF statement

[pao13]

Hi. I would like to add to this IF statement IF(AND($F4=0,C4>E4),0,BlackScholes($C4,$E4,0.125%,$F4,2.6%,$D4%,"P",0,0)) that if $F4=0 and C4<E4 I want the answer to be E4-C4.

How can I do that?

Thanks

 

[eibi]

How about...

=IF(AND($F4=0,C4<E4), E4-C4, IF(AND($F4=0,C4>E4),0,BlackScholes($C4,$E4,0.125%,$F4,2.6%,$D4%,"P",0,0)))

 

[pao13]

Thanks! I knew it was easy but I was stuck.

 

[Vishal.jagani]

Hello eibi,
I have issue in If() with multiple condition
actually I know Ti's not big deal but I am confused now

There is column E has different numbers
and output should be "massages" in column H
Exa:
Column E Column H(output)
0.00 - "Simple charge 5,60 Euro"
0,00 - "Simple charge 5,60 Euro"
5,60 or 5.60 - "simple charge 5,60 Euro"
8,00 or 8.00 - "simple charge 5,60 Euro"
10,95 or 10.95- "Standard 14,95 Euro"
24,95 or 24.95 - "DHL Exress 29,95 Euro"
30.00 or 30,00 - "Special dilivery 45,95 Euro"

In column E has only one data from above I mean it could be 5.60 or it could be 5,60 or it could be 8,00 or 8.00

I want output only massages in column H which are against those numbers

Thnks
Vishal

 

[jayalaxmi]

Hello eibi,
I have issue in If() with multiple condition
actually I know Ti's not big deal but I am confused now

There is column E has different numbers
and output should be "massages" in column H
Exa:
Column E Column H(output)
0.00 - "Simple charge 5,60 Euro"
0,00 - "Simple charge 5,60 Euro"
5,60 or 5.60 - "simple charge 5,60 Euro"
8,00 or 8.00 - "simple charge 5,60 Euro"
10,95 or 10.95- "Standard 14,95 Euro"
24,95 or 24.95 - "DHL Exress 29,95 Euro"
30.00 or 30,00 - "Special dilivery 45,95 Euro"

In column E has only one data from above I mean it could be 5.60 or it could be 5,60 or it could be 8,00 or 8.00

I want output only massages in column H which are against those numbers

Thnks
Vishal

pls post a new thread for it..read forum rules..and pls attach a sample rather than copy pasting the data