First, in your original formulae, SUM() is superfluous:

=IF(K11="","",K11/AB12*1000)
=IF(K140,IF(K11<"",K14+K11,""),"")

are equivalent.

To use OR:

=IF(K140,IF(OR(K11<"",K110),K14+K11,""),"")

However, that's relatively meaningless since if K110, it is by
definition not a null string. Since a null string will be interpreted as
0 in a comparison involving numbers, you can simply use

=IF(K140,IF(K110,K14+K11,""),"")

or, more efficiently

=IF(AND(K140,K110),K14+K11,"")



In article ,
"Ron" wrote:

Hello,

I have a cell (cell1) with this formula

=IF((K11)="","",SUM((K11)/(AB12))*1000)

Then I have another cell (cell2) which derives its value
from cell1 (and another cell)

=IF((K14)0, IF((K11)<"",SUM(K14+K11),""),"")

If the value in cell1 = 0 then I want to modify the
formula for cell2 (pseudocode here) to look something like
this:

=IF((K14)0, IF((K11)<"" OR ((K11) 0),SUM
(K14+K11),""),"")

Obviously, this formula doesn't work. Is there a way to
write a formula with an OR clause along with the IF
statement?

Thanks,
Ron