Search results for query: *

This formula is working PERFECT.... =IF((P4=1)*(R4=1)*AND(T4=1),1,0) NOW I NEED TO ADD "C1"... I MEAN... P4="1 RA4=1 T4=1,1,0 P4="C1" RA4=1 T4=1,1,0 P4=1 RA="C1" T4=1,1,0 P4=1 RA=1 T4=C1,1,O P4"C1" RA"C1" T4"C1",1,0... in other words count "c1" as 1 thank you!! Thanks.... Jatolo

I need to subtract from 2 differents cells,,,, This is the formula subtracting from one cell EZ11 =SUM(C11:EQ11)-EZ11 Now I need to subtract from cell FA11 as well... All this...=SUM(C11:EQ11) minus EZ11 AND FA11 Thanks... Thanks.... Jatolo

=IF($BL$64="","",IF(BL3=$BL$64,1,0)) I NEED TO CHANCE THE ABOVE FORMULA TO: IF $BL$64="A" THEN BL3=1,0 IF $BL$64="B",THEN BL3=1,0 IF $BL$64="C",THEN BL3="C1",0 ONCE AGAIN JUST WHEN IT SHOWS "C" THE RESULT SHOULD BE C1 or 0 THANKS FOR YOUR HELP!!! Thanks.... Jatolo

1 2 3 4 5 6 7 8 9 10 joe Doe A C B C C A B A A C John P. C B A A A C B B C B MARY S. A C B B C C A A B C I have about 60 persons with diferents scores(A,B,C)in 10 games... Is there any way to find out if two persons has chosen the same scores.....coincidentally. Thanks very much...

=COUNTA(D3,F3,I3,K3,M3,P3,R3,T3,W3,Y3,AA3,AD3,AF3,AH3,AK3,AM3)+COUNTA(AO3,AR3,AT3,AV3,AY3,BA3,BC3,BF3,BH3,BJ3,BM3,BO3,BQ3,BT3,BV3,BX3,CA3, Why is counting the BLANK cells... "I can't use Del key because there's a formula that I need... Thnks...

=IF(E9>E10,"A",IF(E9<E10,"B",IF(E9=E10,"C"))) Can someone help me... As you see if there any score the results are A , B, C... now if there's no scores I'd like to show empty cell.... Thanks for your help!!!

Hi guys!!! I have about 100 folders and I'd like to have the same icon on each folder.. Is there any way to do it all of them at once... Tks.

Hi there!!! I have 1 terabite HDD, with mp3 and mpeg files, I'd like to know how to protect this HDD with password, I want to prevent from moving my files out without my permission?? Tks

Hi!!! quick question.. this formula is working great the only thing is; if G36 y G37 are empty I'd like to see an empty cell instead 0. =IF(G36>G37,"A",IF(G36<G37,"B",IF(G36=G37,"C"))) thanks...G36:G37="",""?????? iS THIS GOOD Thanks

Hi.... I have this formula in about 100 cells, =IF(OR(AND(C7=$C$4,D7=$D$4)),1,0,) I just need to replace the NUMBER 1 FOR NUMBER 2... Do I have to replace every single cell one by one? or Is there any way to do everyones at once? Thanks for your help...

Hi, I have all my work done, tables with formulas, Validations, Conditionals Formating etc. and data.. I just want to delete the data, and keep everything else, also I wanto to e-mail this job, but I'd like to hide (formulas etc) Thanks for your help.

I need please help with this "formula", two options one winner. Score C4 D4 3 0 Option A: C5 D5 2 2 Option B: C6 D6 3 3 Winner D7=1 Point C5 D5 Match C4 D4 or C6 D6 match C4 D4 =If(C5=C4)and(D5=D4)or(C6=C4andD6=D4),1,0 Thanks for your help

Hi guys Once again.... I have 10 worksheets in one workbook, How can I select which worksheets I need to print???? o how can I print all of them at once?? Thanks for your support........

AMOUNT PYMT $300.00 Ch# 2343 $2,000.00 $0.00 $45.00 Ch# 2346 $70.00 Conf.# 4563 $3,455.00 $0.00 $5,870.00 Can anyone help me, please. I'm trying to "write" this FomulA, to have a balance but.... I giving up.... =IF(B2:B6<>0,C8-(SUM(A2:A6)) Thanks for your help....

Hi guys!!!! Is there any way for EXCEL to ask "Do you want to protect this worksheet" before I close it. I Must protect every worksheet, I keep forguering.... Thanks