Problem

[Guest]

=IF(D5=0,B5,D5+B5*(B5>30))

I am currently using this formula for a spreadsheet, what I need to do is
modify it so that I can also Ignore the value in column D if Column A has 3
different words in it, the words are Online, Page and Task. Please can anyone
help?

Thanks in advance

 

[Guest]

sorry I have sorted this now

 

[JulieD]

Hi

not sure on what you mean by "ignore the value in column D"
also not sure if you need all three words to be in column A or only one of
the three (assumed the later - if the former is true change OR to AND)
however, here's one approach that might get you started on a solution
=IF(OR(COUNTIF(A:A,"Online")>=1,COUNTIF(A:A,"Page")>=1,COUNTIF(A:A,"Task")>=1),"",IF(D5=0,B5,D5+B5*(B5>30)))

Cheers
JulieD