View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Shannon Shannon is offline
external usenet poster
 
Posts: 53
Default Formula Help please

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