$$Excel-Macros$$ Re: IF Condition

2009-08-07 Thread Ravi Kumar Vandavasi
=IF(B45,IF(E42,IF(H42,Yes,No), No), NO) On Aug 6, 5:53 pm, Putta Madaiah puttamada...@gmail.com wrote: Hi All, Can anyone provide me the formulas as per the requirement in the attachment. Rgds, Putta - Bangalore  Formula.xlsx 35KViewDownload

$$Excel-Macros$$ Re: Appending formula

2009-09-14 Thread Ravi Kumar Vandavasi
Dear Prashanth, Append your formula like this. This should help. =IF(OR(D16=Summary!$C$3,C16=AAA, C16=BBB, C16=CCC),High,IF (D16Summary!$C$3,Medium,Low)) Regards, V Ravi Kumar On Sep 14, 10:18 am, Prashanth Banneni praba...@gmail.com wrote: Hi All, I have a query, which needs to be

$$Excel-Macros$$ Reading custom format as it appears in a cell

2012-03-28 Thread Ravi Kumar Vandavasi
characters by custom format. Please tell me how to read masked characters by custom format. Thanks Regards, Ravi Kumar Vandavasi -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula

Re: $$Excel-Macros$$ Reading custom format as it appears in a cell

2012-03-29 Thread Ravi Kumar Vandavasi
...@gmail.com *From:* Ravi Kumar Vandavasi friendswrite...@gmail.com *Sent:* Tuesday, March 27, 2012 10:39 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Reading custom format as it appears in a cell I have an excel file each cell may have different custom formats

Re: $$Excel-Macros$$ Reading custom format as it appears in a cell

2012-03-29 Thread Ravi Kumar Vandavasi
. Regards, Ravi Kumar On Wednesday, March 28, 2012 9:01:36 PM UTC-7, NOORAIN ANSARI wrote: Dear Ravi, Please use =REPT(0,15-LEN(A2))A2 instead of Custom format.. then you can easly count lenght.. See attached sheet. On Tue, Mar 27, 2012 at 9:09 PM, Ravi Kumar Vandavasi friendswrite

Re: $$Excel-Macros$$ Vlookup in Macro

2010-12-13 Thread Ravi Kumar Vandavasi
U can use on error goto msg msg: Inputbox() On Dec 13, 9:52 am, Raj Mahapatra rajafs...@gmail.com wrote: hi Vaibhav, thanks for this. but i want to dispaly an input box as *lookfor is not in the rng* while there is error. On Fri, Dec 10, 2010 at 1:32 PM, in.vaib...@gmail.com wrote: