Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro wait 30 seconds then Complete the Macro | Excel Discussion (Misc queries) | |||
newbe with a formula question. | Excel Discussion (Misc queries) | |||
Newbe help with a lookup | Excel Discussion (Misc queries) | |||
Newbe Help with count/countif function | Excel Worksheet Functions | |||
Macro Code Question for Newbe | Excel Programming |