Thread: Problem
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
GBH99 GBH99 is offline
external usenet poster
 
Posts: 28
Default 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