If formular

New Contributor

Dear All,


I need a little help with a "no" or "on hold" formular. 


If "no" or "on hold" is entered in to cell F:4 then dont run formular (L4+K4) in cell L:4

So if I enter "yes" in cell F:4 the formular in cell L:4 should be used.


Currently using the following but not sure how to add the second IF "on hold" =IF(F4<>"no",I4+K4,"")


Hope tihis makes sence. 

2 Replies


Like this:


=IF(OR(F4={"no","on hold"}),"",I4+K4)

Thank you Hans - Worked Perfectly