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.