Search results

Hi, I am having a problem with my list of data. Here is the back ground the figure provided in column E is the total number of leaflets that I received , i want to ensure that no individual (listed in column A) gets less than 5. I also want to ensure that the overall total of column B is...

Hui, Thanks for explanation, now I can understand the problem I am having, no wonder it did not work correctly. Still new to excel formulas.

Hi all I have posted a link to the doc, hope you can open it. Doc

Thanks for your help, but am I still getting a zero in col B when I use the formula '=IF(OR(C5<=5,B$46<0),"YES","NO")' Here is the data. In column C I am using the following formula '=ROUND(SUM(F$3 * D5),0)' in order to multiply the weighting in col D X 150, the number I get in C is...

Hi, I get a zero as the result of this formula when I was expecting the answer Yes (my test answer) Here is the formula =(IF(C5<=5,(5),IF(B$46<0,"YES","No"))) Data C5 = 6 B46 = -78 Now in the cell the formula is in, lets say B5 returns 0 if the first IF...

Just wanted to say big thank everybody for all your help.

I have to use Excel 2003 version standard edition. Sorry should have said what version I am using.

Thanks Chandoo for your help. I have a problem though which I did not explain on my original posting, which is that the two columns of data are not next to each other, as each set of values has other columns before and after, as they are part of a much larger financial report. The data also is...

Hi, This is my first posting. I have two columns of data which I need to compare in order to find those values which do not appear in either column. Once found I intend using conditional formating to highlight those values which are not duplicated in either column. For example Column A...