I need help putting this easy formula together

[carloslp]

I want to put all these conditions formulas together, so I can say if it fulfills the conditions say good or bad in column E

----a------------b----------c------------d----------------E
DATE------- inc. flow----Temp.------Susp.solids

01/11/2004----1053-----22---------144---------------good "for example"
02/11/2004----932------20------- 146
03/11/2004---1035-----27-------- 298
04/11/2004---1156-----28---------210
05/11/2004---1297-----27.8-------156
06/11/2004---1318-----28-------- 66
07/11/2004---1117-----25-------- 180
08/11/2004---1520-----27---------200
09/11/2004----1894----26.9------ 110

Conditions for column B47 <2863
Cond for column C47 <30
Cond for column D47 <277

IF(B47="","",COUNTIF(B2,B47)) I want to join it with SI(C47="","",COUNTIF(C2;C47)) and IF(C47="","",COUNTIF(D2;D47))


Thanks for helping I already tried using "and" but It gives me an error thats bringing me crazy...

Thanks for any advise.......

carlos

[Ron Coderre]

Try using this:

=IF($B$47="",1,B2<$B$47)*IF($C$47="",1,C2<$C$47)*IF($D$47="",1,D2<$D$47)

From that equation "good" results calculate to 1, "bad" to zero.

Also: just put the limit values in cells B47, C47, and D47:
2863, 30, and 277, respectively.

Does that help?

Regards,
Ron

[carloslp]

Thanks a lot men it works perfect.......
thanks really

[carloslp]

Eyy Ron , one more question, Sorry for asking againg but I think you are quite a brain in this... how can I graphic , how many of these conditions were not accomplish...

for ex. on monday all of them were acomplish o.k nothing happense but on tuesday they were two of them that did not accomplis .....i want to show in a graphic that they were to on tuesday for ex... and in friday one was not accomplish.


1 ------------------------------------*
2------------*
3
4
5
6
Mond Tuesd wed thurs friday sat sunday


Thanks again and now I owe you big time..