what if C6 is not between 1 and 4 in each instance of C18?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Foghat" wrote in message
...
Many thanks Bob that really helped

I have one other problem which should enable me to complete this
spreadsheet
if you could help

Here goes

If C18 is between 1 and 4 and C6 is between 1 and 4 then the answer is
C48,
If C18 is between 5 and 8 and C6 is between 1 and 4 then the answer is
C48x2
if C18 is between 9 and 12 and C6 is between 1 and 4 then the answer is
C48 X
3 +C45

there are alot of different variables in this spreadsheet so I dont know
if
this is the right way to be doing it or is there another way which it can
be
done

Many thanks in advance for everyones help

Craig



"Bob Phillips" wrote:

=IF(AND(C6=1,C6<=4),C45+C46,IF(AND(C64,C6<=8),C4 5+C46*2,IF(AND(C68,C6<=12),C45+C46*3,"")))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Foghat" wrote in message
...
I want to programme so that if C6 is between 1 and 4 then the answer is
Sum
of C45 and C46, if C6 is between 5 and 8 then the answer is sum of C45
and
C46(X2), if the C6 is between 9 and 12 then the answer is sum of C45
and
C46(X3)