Complete Newbe - Is this a MACRO function or VB ?

Hi -

Sorry to bother with such a simple question - but I am unable to get this
logic script to work. I'm sure that I'm missing something very simple - I
apologize in advance!

If G10 is between 1 and 8 then G14 = 2995, if G10 is between 9 and 16 then
G14 = 3995, if G10 is between 17 and 24 then G14 = 4995, if G10 is between 25
and 32 then G14 = 6995, if G10 is > than 32 then G14 = 8395

Any thoughts? Where do I place this logic? In the cell (G10), or as a
"blind/hidden" cell somewhere else?

Thanks again.

I will assume the values of interest can be integers only (since
otherwise you have lots of undefined possibilities). Create a table
in, say, $A$8:$B$12 that contains:

1 2995
9 3995
17 4995
25 6995
33 8395

Then, use =VLOOKUP(G10,$A$8:$B$12,2)
--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <[email protected]>,
[email protected] says...
> Hi -
>
> Sorry to bother with such a simple question - but I am unable to get this
> logic script to work. I'm sure that I'm missing something very simple - I
> apologize in advance!
>
> If G10 is between 1 and 8 then G14 = 2995, if G10 is between 9 and 16 then
> G14 = 3995, if G10 is between 17 and 24 then G14 = 4995, if G10 is between 25
> and 32 then G14 = 6995, if G10 is > than 32 then G14 = 8395
>
> Any thoughts? Where do I place this logic? In the cell (G10), or as a
> "blind/hidden" cell somewhere else?
>
> Thanks again.
>
>

Put this formula in G14

=IF(G10>=1,IF(G10<=9, 2995,IF(G10<=16, 3995,IF(G10<=24, 4995, IF(G10<=32,
6995, 8395)) ) ),0)
--
HTH...

Jim Thomlinson


"Justin" wrote:

> Hi -
>
> Sorry to bother with such a simple question - but I am unable to get this
> logic script to work. I'm sure that I'm missing something very simple - I
> apologize in advance!
>
> If G10 is between 1 and 8 then G14 = 2995, if G10 is between 9 and 16 then
> G14 = 3995, if G10 is between 17 and 24 then G14 = 4995, if G10 is between 25
> and 32 then G14 = 6995, if G10 is > than 32 then G14 = 8395
>
> Any thoughts? Where do I place this logic? In the cell (G10), or as a
> "blind/hidden" cell somewhere else?
>
> Thanks again.
>

In G14 put in the formula

=IF(G10<1,"",IF(G10<25,TRUNC((G10-1)/8)*1000+2995,IF(G10<32,6995,8395)))

--
Regards,
Tom Ogilvy

"Justin" <[email protected]> wrote in message
news:[email protected]...
> Hi -
>
> Sorry to bother with such a simple question - but I am unable to get this
> logic script to work. I'm sure that I'm missing something very simple - I
> apologize in advance!
>
> If G10 is between 1 and 8 then G14 = 2995, if G10 is between 9 and 16 then
> G14 = 3995, if G10 is between 17 and 24 then G14 = 4995, if G10 is between
25
> and 32 then G14 = 6995, if G10 is > than 32 then G14 = 8395
>
> Any thoughts? Where do I place this logic? In the cell (G10), or as a
> "blind/hidden" cell somewhere else?
>
> Thanks again.
>

Put this in G14

=VLOOKUP(G10,{0,2995;9,3995;17,4995;25,6995;33,8395},2)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Justin" <[email protected]> wrote in message
news:[email protected]...
> Hi -
>
> Sorry to bother with such a simple question - but I am unable to get this
> logic script to work. I'm sure that I'm missing something very simple - I
> apologize in advance!
>
> If G10 is between 1 and 8 then G14 = 2995, if G10 is between 9 and 16 then
> G14 = 3995, if G10 is between 17 and 24 then G14 = 4995, if G10 is between
25
> and 32 then G14 = 6995, if G10 is > than 32 then G14 = 8395
>
> Any thoughts? Where do I place this logic? In the cell (G10), or as a
> "blind/hidden" cell somewhere else?
>
> Thanks again.
>

Thanks to both of you - they both work very well.

Thanks again!

"Justin" wrote:

> Hi -
>
> Sorry to bother with such a simple question - but I am unable to get this
> logic script to work. I'm sure that I'm missing something very simple - I
> apologize in advance!
>
> If G10 is between 1 and 8 then G14 = 2995, if G10 is between 9 and 16 then
> G14 = 3995, if G10 is between 17 and 24 then G14 = 4995, if G10 is between 25
> and 32 then G14 = 6995, if G10 is > than 32 then G14 = 8395
>
> Any thoughts? Where do I place this logic? In the cell (G10), or as a
> "blind/hidden" cell somewhere else?
>
> Thanks again.
>

Which both? Four of us replied <g>

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Justin" <[email protected]> wrote in message
news:[email protected]...
> Thanks to both of you - they both work very well.
>
> Thanks again!
>
> "Justin" wrote:
>
> > Hi -
> >
> > Sorry to bother with such a simple question - but I am unable to get
this
> > logic script to work. I'm sure that I'm missing something very simple -
I
> > apologize in advance!
> >
> > If G10 is between 1 and 8 then G14 = 2995, if G10 is between 9 and 16
then
> > G14 = 3995, if G10 is between 17 and 24 then G14 = 4995, if G10 is
between 25
> > and 32 then G14 = 6995, if G10 is > than 32 then G14 = 8395
> >
> > Any thoughts? Where do I place this logic? In the cell (G10), or as a
> > "blind/hidden" cell somewhere else?
> >
> > Thanks again.
> >