Formula / Macro Question

[Bradley H Callender]

Is there a formula / macro that can do the following:

if one cell has the value "Not Applicable"
if skips a calculated column and leaves the solution cell empty

 

[doofusboy]

Embedding an If statement in your formula should work. Something like this:

=IF(certain cell = "Not Applicable", "", your regular formula here)

 

[Bradley H Callender]

ok Thanks but i don't think this is going to work. here is qiuck example of what i'm doing.

i Have dates in range J1:J357 these dates are they calculated using "=today()-j1" going down in that pattern in range k1:k357 but in range j1:357 some dates are not applicable and in calculating i end up with a "#VALUE!".

SO WHAT DO I USE THEN TO LEAVE THE CELL BLANK RANGE "K1:K357"IF ONE OF THE CELLS IN RANGE "J1:J357" CONTAIN "NOT APPLICABLE"?

 

[Bradley H Callender]

please disregard my above post

 

[Bradley H Callender]

Hi can you use an "or" in the logic function?

i want to go "Not applicable" or " " <----- Blank

 

[doofusboy]

=IF(OR(certain cell = "Not Applicable",certain cell = ""),"", your regular formula here)

" " would mean cell has space in it

"" would mean cell is blank