Excel Discussion (Misc queries) - Page 27

Thread / Thread Starter	Last Post	Replies	Views
=IF(A1=MAX($A$1:$A$3),A1,"") Adapt to use multiple "if" formula's tssgraham	by MartinW	7	630
=IF(A2="","",TEXT(A2,"dddd")) Jim	by David Biddulph[_2_]	3	1,214
=IF(ABS(1-(H11/G11)<ABS(0.01)),"VALID","INVALID") Dave F	by David Biddulph	15	1,205
=if(and ?? MyKool	by MyKool	4	335
=IF(AND equation not applying to whole document) Boethius1	by Boethius1	3	322
=IF(AND(' Job Duties Description'!S50,' Job Duties Description'!S5 Chad	by Francis	3	443
=IF(AND(. . . ???? John DeLosa	by Shane Devenshire[_2_]	5	433
=IF(AND(B1D1)=C1-1,IF(AND(D1B1)=C11)) Dolphinsblue	by T. Valko	7	536
=IF(AND) equation pulls through N/A cells Boethius1	by Boethius1	0	350
=IF(AND... function Mukesh	by David Biddulph[_2_]	6	500
=IF(B25="",ROUND(O25,-2),"") Nick C	by Rick Rothstein $MVP - VB$[_952_]	3	262
=IF(B8="M","HI") OK but =IF(B8="M","HI")+IF(B8="x","bye") not why Nater	by pinmaster	4	306
=IF(C16<>"",C16,0.4) fei	by Bill Martin -- (Remove NOSPAM from address)	4	337
=IF(C7=0,"",AVERAGE(H7:H11)) - doesn't work japc90	by Marcelo	3	449
=IF(COUNTIF to search several groups of cells Spamn	by T. Valko	3	1,411
=IF(D13="PAID","YES","NO") Can I change fonts colour Kev	by exceluserforeman	3	2,419
=IF(Input_Sheet!D52="","",Input_Sheet!D52) Jim	by Jim	2	428
=IF(ISERROR(VLOOKUP(A3,contacts!B:I,5,FALSE)), " ", VLOOKUP(A3,con Jim	by Jim Thomlinson	4	1,636
=IF(ISERROR(VLOOKUP(F2,Content_Insert!A:A,1,0)),"" ,VLOOKUP(F2,Mast Jim	by David Biddulph[_2_]	3	1,238
=IF(ISNA + VLOOKUP? GD	by T. Valko	4	455
=IF(ISNA(VLOOKUP(A1,Data!$B$1:$C$200,MATCH(A1,Data !$A$1:$C$1,IF($V nv77078	by Luke M	3	1,291
=IF(ISNA) Question - - -! Wildwood	by Jim Thomlinson	2	382
=IF(ISNONTEXT(Sheet1!C2),(A5=A5+1),(A5=1)) famdamly	by Ron Rosenfeld	1	537
=IF(L5<"",TODAY()-L5+1,"") Michell Major	by Michell Major	7	491
=If(Macro) AntnyMI	by Tom Ogilvy	1	316
=IF(OR(TODAY()G9),"Pass","Overdue") Why doe it not wo. Fkor	by Kassie	3	1,060
=IF(Range=Range, Range) hooper222	by RagDyer	3	270
=indeks({14,10};SAMMENLIGN(D5;{"testJacob Schmidt"};0)) Kamalonen	by Kamalonen	0	912
=Index Problem Nikki	by Peo Sjoblom	5	583
=INDEX($B$2:$P$2,COLUMNS(B$2:$P$2)) Dave F[_2_]	by RagDyeR	3	1,089
=INDEX(BUSINESS,MATCH(B2,EIN,0)) Gary Reger[_2_]	by Gary Reger[_2_]	3	312
=INDEX(C3:N22,MATCH(G26,B3:B22),MATCH(H26,C2:N2)) Dave F	by Dave F	11	1,164
=INFO("memused") Dave F	by BoniM	1	717
=ISFUNCTION Neil Pearce	by Luke M	5	794
=LARGE and cells equaling 0 M.A.Tyler	by Ragdyer	6	416
=large formula [email protected]	by JMB	1	415
=LARGE problems Adam	by T. Valko	2	550
=left of decimal The Rook[_2_]	by Dave Peterson	2	3,266
=left or =right The Rook[_2_]	by MartinW	6	285
=LOOKUP(100^10,D:D) Gilbert	by T. Valko	2	323
=max.if.group doesn't work - so how I can... Anssi	by Luke M	1	713
=Mid Formula Chris waller	by Chris waller	4	339
=MIN() Function claude jerry	by claude jerry	4	425
=month formula no working PG	by PG	4	685
=NOT(ISNUMBER(RIGH(V670,5))) Dave F[_2_]	by Dave F[_2_]	4	1,279
=now() changed to absolute apon saving des-sa[_2_]	by Gord Dibben	2	314
=NOW() from changing Richard	by JE McGimpsey	5	406
=PRODUCT billy-bob	by billybob	6	433
=PROPER Snowcap	by Lady Layla	1	370
=PROPER Snowcap	by Snowcap	2	405
=PROPER() Mukesh	by Mukesh	2	458
=RAND produces decimals not whole numbers moosegate	by Tushar Mehta	9	715
=RATE(17,1,-5) returns #NUM! but the answer should be about 18.9 hapster	by Fred Smith	2	404
=ROUND((ROW()-10)!G$66,L$3) ... what's the error? tripflex	by Ron Rosenfeld	3	524
=SF_Load!A2 Jim	by Dave Peterson	2	480
=Sheet!A1 formula alternative RLD	by T. Valko	2	1,705
=Sheet1!A1 - with a blank entry!!! CP	by CP	2	483
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE.... max. limit 8 :( [email protected]	by T. Valko	6	1,131
=sum #value! error TanaMary	by Peo Sjoblom[_2_]	9	480
=sum not working SLP	by SLP	8	473
=SUM problems in totalling figures the-chosen-one	by Dave Peterson	2	417
=SUM('Wkly stats'!$E6) How do i unfreeze the 6 when i drag cell AP1927	by Dave O	1	347
=SUM((C2:C7000="Friday")*(F2:F7000="8:00:00 AM")) not adding chubbybat	by Jon Peltier	9	596
=sum() for multiple sheets? tripflex	by NBVC[_45_]	2	658
=sum(4150/(1-(.39+.10)) why does this not calculate out to = 8137 Dave Keister	by Jerry W. Lewis	5	348
=sum(a1:a5)&"+(b5)" Shadez	by Shadez	3	507
=SUM(A1:ABOVE) CEG	by Alan	17	865
=SUM(E4:I4) WILL NOT ADD THE LINE fly4rnr	by smartin	1	432
=sum(if HELP!!!!!!!!! kp0250	by kp0250	0	476
=Sum(if( Pritesh	by Bob Phillips	3	402
=sum(if(a1=b1,1,0),if(a2=b2,1,0),if(a3=b3,1,0),... ..) Farkas Attila	by Pete_UK	2	2,561
=SUM(Sheet2:Sheet9!IV65536)-meaning of equation? djc	by Peo Sjoblom	2	641
=SUMIF Kevin	by Kevin	4	363
=SUMIF Help!! [email protected]	by Gary''s Student	2	360
=SUMIF Problem doctorjones_md	by JON JON	1	413