Excel 2003 - Jacob, need ur help again please?
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)
|