Further to the answer below, I need the following in one formula! Thank you
for looking.

If Cell A1(Text) = X or Y or Z and Cell B1 is Mon or Tue or Wed or Thur or
Fri then multiply Cell C1(Number) with (£17.00) into F1(£Total) but

If Cell A1(Text) = X or Y or Z and Cell B1 is Sat then multiply Cell
C1(Number) with (£20.00) into F1(£Total) but

If Cell A1(Text) = X or Y or Z and Cell B1 is Sun then multiply Cell
C1(Number) with (£25.00) into F1(£Total) but

if Cell A1 = V and Cell H1 is between time (0001-0700) then multiply C1 with
(£15.00) into F1(£Total) but

if Cell A1 = V and Cell H1 is between time (0700-1800) then multiply C1 with
(£10.00) into F1(£Total) but

if Cell A1 = V and Cell H1 is between time (1801-2359) then multiply C1 with
(£20.00) into F1(£Total)


Jacob Skaria 11/24/2009 11:38 AM PST
Answer
Try
=IF(SUM(COUNTIF(A1,{"X","Y","Z"})),C1*D1,IF(A1="V" ,C1*E1,""))

If this post helps click Yes
---------------
Jacob Skaria


"Sexy Devil" wrote:

If Cell A1(Text) = X or Y or Z then multiply Cell C1(Number) with D1(£) into
F1(£Total) but if Cell A1 = V then multiply C1 & E1(£) into F1(£Total)