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) |
All times are GMT +1. The time now is 10:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com