using OR with IF function?
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
|