ExcelBanter - Excel 2003 -

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Excel 2003 - (https://www.excelbanter.com/excel-discussion-misc-queries/249278-excel-2003-a.html)

Sexy Devil

Excel 2003 -

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)

Jacob Skaria

Excel 2003 -

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)

Sexy Devil[_2_]

Excel 2003 -

Thanks Jacob, very much appreciated. x

"Jacob Skaria" wrote:

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 03:21 AM.