$$Excel-Macros$$ Re: formula help

2008-12-10 Thread chandra Singh Bora
Hi Can you help me please. i want excel password breaker.,. On Wed, Dec 10, 2008 at 7:47 AM, watmatt <[EMAIL PROTECTED]> wrote: > > Thanks to all for their help.!!! > > -m > > On Dec 6, 2:31 pm, watmatt <[EMAIL PROTECTED]> wrote: > > Can you help me please? I have a bit of a situation and I

$$Excel-Macros$$ Re: formula help

2008-12-09 Thread watmatt
Thanks to all for their help.!!! -m On Dec 6, 2:31 pm, watmatt <[EMAIL PROTECTED]> wrote: > Can you help me please?  I have a bit of a situation and I need some > fresh eyes and brain power. I am trying to set up a spreadsheet for my > dad in excel and I have run into a formula snag. This is the

$$Excel-Macros$$ Re: formula help

2008-12-08 Thread Raghuveer
Dear watmatt Here is the formulae you required: =IF(A1<50,B2*(1.5),IF((A1>50)*AND(A1<100),B2*(1.4),IF((A1>500),B2*(0.97),IF((A1>1000),B2*(0.95),0 But if you put this formula in B2 cell. It will create circular reference. You can look into the given attachment. Cheers.. Govind On Sun, Dec 7,

$$Excel-Macros$$ Re: formula help

2008-12-07 Thread Tom Jeffries
What you describe is best accomplished by a macro rather than a formula . Take a look at the attached function (GetValue). If you have any questions let me know Tom On Sat, Dec 6, 2008 at 3:31 PM, watmatt <[EMAIL PROTECTED]> wrote: > > Can you help me please? I have a bit of a situation and I

$$Excel-Macros$$ Re: formula help

2008-12-07 Thread Ajit Navre
Try the following formula =B2+B2*INDEX({-0.05,-0.03,0,0,0,0.4,0,0.5},MATCH(A1,{2000,1000,500,499,100,9 9,50,49},-1)) Values Of A1 Operation == Upto 49 B2 * 50% 50 Unchanged 51 to 99B2 * 40% 100 to 500 Un