This one has me stumped, can anybody help.

[nyrfan]

How do I write this formula?

If e5 contains a # >0 then e5+k5* 3%, if e5 is <0 then k5 / L5


Thanks,
Felix

 

[texasalynn]

is this what you need?
=if(e5>0,e5+k5* 3%,k5/L5)

 

[Lewiy]

=IF(E5>0,(E5+K5)*0.03,IF(E5<0,K5/L5))

 

[Domski]

Hi,

Try:

=IF(E5>0,E5+K5*0.03,IF(E5<0,K5/L5,0))

Dom

 

[nyrfan]

Each one workd great thanks

Felix

 

[Domski]

They may all work but bear in mind that you get a different answer for (E5+K5)*0.03 than to E5+K5*0.03 due to the postioning of the parenthesis.

Dom