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.

Complete Newbe - Is this a MACRO function or VB ?
 

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 ,
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.

Complete Newbe - Is this a MACRO function or VB ?
 

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.

Complete Newbe - Is this a MACRO function or VB ?
 

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" wrote in message
...
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.

Complete Newbe - Is this a MACRO function or VB ?
 

Put this in G14

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

--

HTH

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


"Justin" wrote in message
...
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.

Complete Newbe - Is this a MACRO function or VB ?
 

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.

Complete Newbe - Is this a MACRO function or VB ?
 

Which both? Four of us replied <g

--

HTH

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


"Justin" wrote in message
...
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.