Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Colon at the end of excel file name(ex: problem.xls:1, problem.xls | New Users to Excel | |||
Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
problem with a conditional max problem | Excel Discussion (Misc queries) | |||
Problem when multipple users access shared xl-file at the same time, macrocode for solve this problem? | Excel Programming |