ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel 2003 - Jacob, need ur help again please? (https://www.excelbanter.com/excel-discussion-misc-queries/249296-excel-2003-jacob-need-ur-help-again-please.html)

Sexy Devil[_2_]

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