If formular

Copper 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

@catley666 

Like this:

 

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

Thank you Hans - Worked Perfectly