RE: $$Excel-Macros$$ Re: IF Function

2012-05-16 Thread Rajan_Verma
Hi See the discussion on this page http://www.excelforum.com/excel-worksheet-functions/637114-more-than-7-if-st atements.html Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of CoRe Sent: 16 May 20

Re: $$Excel-Macros$$ Re: IF FUNCTION PROBLEM

2012-02-07 Thread hilary lomotey
Thanks Kris, wow, this index formula makes my work really easy, thanks boss, u r great, On Tue, Feb 7, 2012 at 4:27 PM, Kris wrote: > Hi > > You are welcome !! > > BTW, you could replace the P7 formula with > > =INDEX(I4:I26,A1) > > Kris > > -- > FORUM RULES (986+ members already BANNED for viol

Re: $$Excel-Macros$$ Re: IF FUNCTION PROBLEM

2012-02-07 Thread Kris
Hi You are welcome !! BTW, you could replace the P7 formula with =INDEX(I4:I26,A1) Kris -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice

Re: $$Excel-Macros$$ Re: IF FUNCTION PROBLEM

2012-02-07 Thread hilary lomotey
Thanks Kris, very helpful On Tue, Feb 7, 2012 at 4:13 PM, Kris wrote: > Hi, > > Replace your Col I formula. In I4 and copied down, > > =IFERROR(C4/C3-1,"N/A") > > custom format the cell as *0.00%;(0.00%)* > * > * > Kris > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use