My reading of this is that you need different formulae in D27, D28, etc.

Here are the first two

=IF(AND(L6="x",K6<=C27),I6*J6,"")

=IF(AND(L6="x",K6=B28,K6<=C28),I6*J6,"")

you should be able to work out the rest.

--
---
HTH

Bob

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



"Shannon" wrote in message
...
I have a problem I just cant seem to get solved.

If a cell (L6) contains an "x" and if cell (K6) is = to or < than cell
(C27)
(multiply cell (I6) by cell (J6)) and those results by cell (D27) = VALUE

HOWEVER, IF cell (K6) is = to or than cell (B28) but = to or < cell
(C28)
(multiply cell (I6) by cell (J6)) and those results by cell (D28) = VALUE

HOWEVER, IF cell (K6) is = to or than cell (B29) but = to or < cell
(C29)
(multiply cell (I6) by cell (J6)) and those results by cell (D29) = VALUE

HOWEVER, IF cell (K6) is = to or than cell (B30) but = to or < cell
(C30)
(multiply cell (I6) by cell (J6)) and those results by cell (D30) = VALUE

HOWEVER, IF cell (K6) is = to or than cell (B31) but = to or < cell
(C31)
(multiply cell (I6) by cell (J6)) and those results by cell (D31) = VALUE

HOWEVER, IF cell (K6) is = to or than cell (B30) (multiply cell (I6) by
cell (J6)) and those results by cell (D32) = VALUE