Problem
 

=IF(D5=0,B5,D5+B5*(B530))

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

Problem
 

sorry I have sorted this now

"GBH99" wrote:

=IF(D5=0,B5,D5+B5*(B530))

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

Problem
 

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*( B530)))

Cheers
JulieD


"GBH99" wrote in message
...
=IF(D5=0,B5,D5+B5*(B530))

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